Sub-Select problem
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 | |||
Вложения
В списке pgsql-admin по дате отправления: