Blogs from Wise Owl on Joins in SQL

Using OUTER and CROSS APPLY joins to link to table-valued functions

Posted by Andy Brown on 03 May 2013

For the sake of completeness, this blog explains how to join to the results of table-valued functions (like a correlated subquery on steroids).

Writing inner joins and outer joins in SQL

Posted by Andy Brown on 30 November 2012

An in-depth SQL tutorial on how to create inner joins, left outer joins, right outer joins, full outer joins, cross joins and self-joins!

Free SQL training

Posted by Andrew Gould on 13 February 2012

This article provides a comprehensive tutorial in Microsoft SQL Server, taking you from the basics of writing SELECT statements all the way through to creating complex stored procedures.