Thread: 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

I executed the same query on a command line console and it worked

I think the problem is that I'm using EMS PostgreSQL Manager and

it does not return me anything from the SQL Editor.

 

Thank you for the help.

 

MAGO