3개의 달력데이터 통합..(union all명령어)

Question

[code]

 $query = "SELECT * FROM (select * from g5_trc_write_trcall1001 union all select * from g5_trc_write_g01sch union all select * from g5_trc_write_g02sch union all select * from g5_trc_write_g03sch union all ) WHERE left(wr_1,6) = '$year$sel_mon' ORDER BY wr_id ASC";

[/code]

 

위처럼 union 을 하였는데.. 데이터를 못 불러오네요.. 무엇이 문제일까요?

플래토 · Accepted Answer

"SELECT * FROM (select * from g5_trc_write_trcall1001 union all select * from g5_trc_write_g01sch union all select * from g5_trc_write_g02sch union all select * from g5_trc_write_g03sch union all ) X WHERE left(wr_1,6) = '$year$sel_mon' ORDER BY wr_id ASC";

 

빨강은 제거되어야 하고

파랑은 추가되어야 하고 

이 문제로 보입니다.

3개의 달력데이터 통합..(union all명령어)

답변 1개

공유하기