If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

select statement question???

Hi to all...
I have 6 select statements that start the same

SELECT Store,SUM(ABS(Qty)*Flag) Qty,SUM((abs(Price)*Flag)) Returns$ FROM Transactionswhere Modifier4 and Modifier7 andDate between '03/01/09' and '03/16/09' and
up to this point just that in each other where cases i have different modifier or flags to select...
is there a way i can make one select statement instead of 6...
thanking you in advance...
Rino