Home > mailing lists

Sub-Select problem - Mailing list 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í

From: Charles Haron
Date: 17 July 2003, 21:38:25
Subject: Adding PL/Perl

From: "Marvin"
Date: 17 July 2003, 22:27:19
Subject: Re: Sub-Select problem