tag:blogger.com,1999:blog-16771259.post5040625927642055456..comments2024-03-07T03:02:45.934-08:00Comments on SQL Server Code,Tips and Tricks, Performance Tuning: #BackToBasics: Returning all rows from one table that do not exists in another tableUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-16771259.post-52375334818331193162016-01-18T18:05:06.537-08:002016-01-18T18:05:06.537-08:00??? LEFT JOIN and LEFT OUTER JOIN is the same thin...??? LEFT JOIN and LEFT OUTER JOIN is the same thing (OUTER is an optional keyword)Denishttps://www.blogger.com/profile/13745938552201273794noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-27373780773980242702016-01-18T17:45:57.921-08:002016-01-18T17:45:57.921-08:00To "fix" your left join, you can use a l...To "fix" your left join, you can use a left outer join (outer meaning don't include commonalities between tables).Fredhttps://www.blogger.com/profile/10678537355864071783noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-91227266533694646662016-01-18T17:45:43.227-08:002016-01-18T17:45:43.227-08:00To "fix" your left join, you can use a l...To "fix" your left join, you can use a left outer join (outer meaning don't include commonalities between tables).Fredhttps://www.blogger.com/profile/10678537355864071783noreply@blogger.com