>I don't think SQL can know that the first part of the identifier was neccessarily intended to refer to a table ?
>This lists the reasons:http://msdn.microsoft.com/en-us/library/cc645618.aspx

This was my second perception. :)

OK, that explains it all.

Thanks