SQL Tutorial - 31: Left Outer JOIN

In this tutorial we'll take a look at the LEFT Outer JOIN and see how it is different from the regular JOIN

[@SahitiSeemakurti]

You tutorial is great! Nice and short. However, if you can put a picture of the table you are talking about, on the side of the video at all times, it would be even more helpful!

[@alaapgopalkrishna4401]

Good job sir

[@09ThunderOne]

not a left OUTER join

[@davidbailon773]

Si el título dice left outer join, porque no usaste eso ??

[@saptarshidas8136]

is tutorial_id foreign key?

[@PabloMoricz]

USE test; DESC tutorial; INSERT INTO tutorial (id,title,subject,duration,upload_date) VALUES (18,'Excel Tutorial-1','Microsoft Excel',3.86,'2013-12-11'), (19,'Excel Tutorial-2','Microsoft Excel',4.06,'2013-12-11'), (20,'Excel Tutorial-3','Microsoft Excel',7.03,'2013-12-11'), (21,'Excel Tutorial-4','Microsoft Excel',5.63,'2013-12-11'), (22,'Excel Tutorial-5','Microsoft Excel',6.17,'2013-12-11'); SELECT * FROM tutorial; SELECT * FROM tutorial_info; INSERT INTO tutorial_info (tutorial_id,views,likes,dislikes,shares) VALUES (7,85000,106,25,8), (8,91000,166,24,17), (9,191000,846,48,32), (10,235000,1170,93,52), (11,454000,2070,117,63), (12,51500,2900,131,96), (13,644000,3280,137,12), (14,644000,3280,137,12), (15,329000,1115,143,7), (16,147589,650,22,3), (17,22222,114,12,7), (23,45000,650,131,11), (24,57850,784,146,17), (25,313000,1185,163,19);

[@ernesttwarug3157]

good job, but I found small mistake - one 0 disappeared in row 12 column views should be 515000 than 51500