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