On Thu, 06 Oct 2011 09:43:25 -0000, "tomc7777777" <[email protected]> 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
