[thelist] Re-Using A Sub Query Value
Casey Crookston
caseyc at IntelliSoftmn.com
Thu Jun 22 12:57:30 CDT 2006
Okay, this is a continuation of my previous post. Once you have
selected a value in a sub query, is it possible to reference that value
without performing the sub query again?
Example:
SELECT a.id1, a.item 2, (select b.item3 FROM blah WHERE b.id = a.id) AS
myTotal, a.item4+myTotal AS GrandTotal FROM blah blah WHERE blah blah
Does that make sense?
Thanks,
Casey
More information about the thelist
mailing list