UNION쿼리문좀 봐주세요 정보
UNION쿼리문좀 봐주세요
본문
$sql = "SELECT A.*, '$tmp_bo_table01' as bo_table FROM $tmp_write_table01 A UNION ALL SELECT B.*, '$tmp_bo_table02' as bo_table FROM $tmp_write_table02 B where wr_8 = '1' ORDER BY $options DESC LIMIT 0, $rows";
인데요
wr_8 = '1' 인경우만 불러올려고 하는데
잘안되서요 부탁드립니다.
인데요
wr_8 = '1' 인경우만 불러올려고 하는데
잘안되서요 부탁드립니다.
댓글 전체
$sql = "SELECT A.*, '$tmp_bo_table01' as bo_table FROM $tmp_write_table01 A
where wr_8 = '1'
UNION ALL
SELECT B.*, '$tmp_bo_table02' as bo_table FROM $tmp_write_table02 B
where wr_8 = '1'
ORDER BY $options DESC LIMIT 0, $rows";
where wr_8 = '1'
UNION ALL
SELECT B.*, '$tmp_bo_table02' as bo_table FROM $tmp_write_table02 B
where wr_8 = '1'
ORDER BY $options DESC LIMIT 0, $rows";
감사합니다.^^