Hi all Is there a way to get the output to be on 1 line per Tr_date? I want the output to look like this without using a view?
1/3/2005 25 $500 $200 $100 1/4/2005 15 $400 $100 $50 Not like this 1/3/2005 25 $0 $0 $0 1/3/2005 0 $500 $0 $0 1/3/2005 0 $0 $200 $0 1/3/2005 0 $0 $0 $100 ..... ..... select tr_date,count(distinct custnum),$0.00,$0.00,$0.00,$0.00,$0.00 + from tran_hist where tr_type = 1 GROUP BY tr_date union + SELECT tr_date,0,SUM(ch_price)$0.00,$0.00,$0.00,$0.00 FROM tran_hist + WHERE tr_type = 1 GROUP BY tr_date + UNION + SELECT tr_date,0,$0.00,$0.00,SUM(ch_price)=s,$0.00,$0.00 FROM tran_hist + WHERE ch_code = 'ipay' GROUP BY tr_date several more Unions ...... thanks marc
