>>What if you use the old way:
>>
>>SELECT BiggerQuery.*
>>FROM BiggerQuery
>>LEFT JOIN LesserQuery ON CommonFields
>>WHERE LesserQuery.SomeField IS NULL
>>
>
>I can not seem to make this query compile at all now. It gives me this error
>Msg 8155, Level 16, State 2, Line 45
>No column was specified for column 14 of 'Test'.
>
>UPDATE. I removed bunch of fields and I got 0 result here as well.
:o)))))
Some example data that I could reproduce this?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.