May 21, 2006 at 12:50 pm
The explanation for the result is: In TSQL-style joins, where-clauses for the outer table are used to filter the result set (as expected from a where clause), while clauses for the inner table, as the "o.Rats_filename IS NOT NULL" in the example, go into the on-clause in the corresponding ANSI join. As a consequence, you filtered out rows from the inner table "ratsiiafeedtransaction o", so the outer join puts nulls in the result for these columns. You cannot express what you intended in TSQL-style joins, but rather have to use ANSI joins instead.
May 29, 2007 at 5:43 am
True.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply