Sub-Select problem

Поиск
Список
Период
Сортировка
От Marvin
Тема Sub-Select problem
Дата
Msg-id 3F171D21.000005.03704@guaj215desa
обсуждение исходный текст
Список pgsql-admin
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
_________________________________________________________________
  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Вложения

В списке pgsql-admin по дате отправления: