너무 간단한데 제가 너무 오래 쉬었나 봅니다..
SELECT sum(e_count) as cnt_bm from bmgolfexpenses where e_date between '2008-02-01' and '2008-12-11' and e_sort='1' and e_kind != '7' and e_c_id ='2' and substring(e_barcode,3,2) = '00'
SELECT sum(e_count) as cnt_im from imgolfexpenses where e_date between '2008-02-01' and '2008-12-11' and e_sort='1' and e_kind != '7' and e_c_id ='2' and substring(e_barcode,3,2) = '00'
이걸 하나로 합쳐서 출력하고싶습니다....
출력 결과물은요..
-----------------
|cnt_bm |cnt_im |
-----------------
| 12112| 14114|
-----------------
지나가다가 한번 슬쩍 도와주세요...
|