Martin Boylan

Tag: SQL

  • What’s the difference between an inner and outer join?

    What’s the difference between an inner and outer join?

    This article was taken from programmerinterview.com, and can be found in it’s entirity at http://www.programmerinterview.com/index.php/database-sql/inner-vs-outer-joins/.  I am reprinting it here for my own notes on SQL for future reference.  Many thanks to the author(s) of this article. Joins are used to combine the data from two tables, with the result being a new, temporary table. The temporary…