[thelist] Re-Using A Sub Query Value

[Casey Crookston]

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