[thelist] Re-Using A Sub Query Value

[Casey Crookston]

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