SQLServerCentral.com Articles tagged Outer Joins

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.

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.

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…