Hi all Why are the total for these 2 select statements different??
select custnum,sum(ch_price)=s from tran_hist where tr_type = 1 and inscomp = '7' and tr_date between 6/30/05 and 7/12/05 group by custnum select custnum,ch_price=s from tran_hist where tr_type = 1 and inscomp = '7' and tr_date between 6/30/05 and 7/12/05 group by custnum,ch_price I think the Group by on the second statement causes the numbers to be off because it should be Order by? But I would think I would get an error instead of an incorrect total or am I mixed up? Marc
