How To Join Tables With SQL

When working with databases a common question is how can I join two database tables? In this video on how to join tables with SQL, we work through four examples and explain left join, right join, inner join and full joins. When you want to learn how to join tables in SQL using the primary key you can join tables and also it is a good design to not have duplicated data across the tables, this is discussed as well. This SQL tutorial is part of a series of SQL tips and tricks which can be found here:

⏲⏲⏲TIMESTAMPS⏲⏲⏲
00:00 Beginning
00:14 Inner join
04:36 Left join
07:09 Right join
08:26 Full join
10:34 Subscribe

The blog post with the link to the code for this can be found here:

################ Let's be Social! ##################

#sql #dataanalytics #dataanalyticsireland #jointables #sqljoin #innerjoin #leftjoin #rightjoin #fullouterjoin