Using Aliases in the Where clause??Hlp pls

[Fori]

Hi

i have a quite big sql statement and i would like to ask u if its possible to use aliases in the Where clause and if it is how to use it.

What i'm trying to do is:

SELECT
(SELECT sum(amount) From invoiceDB WHERE Invoice_CustomerID = CustomerID) AS P1

FRom CustomerDB WHERE P1 > 0

Is the above possible?

Thanks
Nick

 

[ThatRickGuy]

try something like this:

SELECT P1
FROM(SELECT SUM(Amount) P1, CustomerID FROM InvoiceDB GROUP BY CustomerID)
WHERE P1> 0


-Rick

 

[JamesLean]

In answer to your general question:

Is it possible to use aliases in the Where clause?

No, you can't do this (although you can refer to aliases in the ORDER BY clause).

--James

 

[Fori]

Thanks james!!

So if i have a big nested select i have to repeat it agian in the where clause?