SQLServerCentral.com Content tagged T-SQL, Outer Joins

LEFT JOIN

Thu, 04 Apr 2013 06:00:00 UT

Outer join with condition

Thu, 27 Dec 2012 07:00:00 UT

Fun with Outer Joins

Mon, 10 Sep 2012 06:00:00 UT

Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

SQL inner and outer joins: Basics for getting started

Mon, 22 Dec 2008 07:00:00 UT

Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.

Writing Outer Joins in T-SQL

Wed, 27 Feb 2008 07:00:00 UT

Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.