연관성 없는 두개의 테이블을 조회해서 두테이블의 값을 다 출력하기
서로다른 테이블 전부 출력하기(union all) select skip 0 first 10 '1' gubn, seq, title, substr(actdate,1,10) as event_date , content, actplace, photoseq, real_photo , qrycnt as index_num FROM chiefact where substr(actdate,1,10) >'2010-06-24' union all SELECT '2' gubn, a.seq, a.title, a.event_date , a.contents as content, a.place as actplace, b.sys_file as photoseq, b.real_file as real_photo, b.index_num FROM m..
더보기