I was trying to do something like this.
Select Field1, Field2, Total
FROM
(Select Field1, Field2, SUM(Field3) as Total
From TableA
Where DateHired <= CAST('08/01/2003' AS DATE)
GROUP BY Field1) as MyTable;
The sub-select query tested alone returns me a lot of rows,
however when I make all the query it returns me nothing.
Please help!!!
I'm in rush.
Thank you in advanced for ANY suggestion,
MAGO