[thelist] Re-Using A Sub Query Value
Casey Crookston
caseyc at IntelliSoftmn.com
Thu Jun 22 14:35:39 CDT 2006
-----Original Message-----
To: peter at easylistbox.com;
Subject: Re: [thelist] Re-Using A Sub Query Value
I'm pretty sure it isn't... but you could make your whole query into a
derived table to do something similar, like this:
SELECT
someColumns
, item4+myTotal AS grandtotal
FROM (
SELECT
someColumns
, (SELECT blahblah) AS myTotal
, item4
FROM blahblah WHERE blahblah
) mainquery
--------------------
I thought so too, but when it hits: item4+myTotal AS grandtotal, I'm
told that myTotal is not a valid column name
:-(
Casey
More information about the thelist
mailing list