On Thu, 06 Oct 2011 09:43:25 -0000, "tomc7777777" <tomconlon7@...>
wrote:

> In other words, I'm unclear how the rows from the sub-select are
> 'materialised' prior to joining to TableA and whether * is needed return
> TB.LINE so as to test for TA.LINE = TB.LINE or not (if that makes

sense!).

Of course not. The fields used in the WHERE clause have no relation to the
fields SELECT clause. One is the condition used to find the records, and
the other are the fields you want to return from the record found.

Mark