SQL Joins Part 1 - Inner, Left Outer and Right Outer
http://www.CodingBlocks.NET
Check out the podcast that sparked this particular video:
http://www.CodingBlocks.NET/episode14
In part one of this video series, we're going to talk about the most common types of joins used:
Inner Join - brings back only records that match each table based on the ON condition
Left Outer Join - brings back all records in the left table, any data that matches in the right table as well, and null for any data in the right table that didn't match the left table in the ON condition
Right Outer Join - brings back all records in the right table, any data that matches in the left table as well, and null for any data in th eleft table that didn't match the right table in the ON condition
Please give this video a thumbs up if you found it helpful and Subscribe to our YouTube channel! The more subscribers we get, the more motivated we'll be to put out more content like this!
Sign up for our newsletter to receive programming advice, tips and tricks:
http://www.CodingBlocks.NET
Check out the Podcast:
iTunes: http://www.CodingBlocks.NET/yt-itunes
Stitcher: http://www.CodingBlocks.NET/yt-stitcher
Follow us on:
Twitter: @CodingBlocks
Facebook: / codingblocks
LinkedIn: / coding-blocks-llc