Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

RE: Expand / Collapse
Posted Sunday, May 21, 2006 12:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 7, 2013 3:56 AM
Points: 3, Visits: 55
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.
Post #281613
Posted Tuesday, May 29, 2007 5:43 AM



Group: General Forum Members
Last Login: Yesterday @ 12:29 PM
Points: 17,173, Visits: 32,140

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #369452
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse