SQL Tutorial - 31: Left Outer JOIN Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 31st to toil in this course and in
this tutorial we are going to talk about
the left outer join operation and for
the sake of this tutorial I have added
some rows in the tutorial table and you
know let me first show you the data that
I have added so to demonstrate that I'll
type in the select keyword and then star
from and then the name of table which is
tutorial and you know basically have
created the you know some rows for
Microsoft Excel subject and you know you
can see that the tutorial number 18 is
Excel tutorial 1 and it belongs to
Microsoft Excel and detour number 19
also belongs to that subject so you know
rows from you know 18 to 22 belong to
that subject basically and you know I
haven't added rows in D to dáil
underscore info table that is you know I
haven't added corresponding rows to
tutorials called info table you know for
Microsoft Excel and I'll show you
tutorial underscore info as well
total underscore info and I put a
semicolon in executed you see that you
know data is missing for tutorials
no numbered 18 to 22 so there is no data
in this table now if I would execute a
simple join query on the two tables then
no data would be returned for the
subject Microsoft Excel and the reason
for that is that you know there are
values present for Microsoft Excel in
the tutorial table but corresponding
values are missing in the tutorial score
info table you know that table has null
values for you know those rows for which
the ID values line between 18 and 22 in
the tutorial table right so if you want
to still see the values from the
tutorial table in your result set then
all you have to do is you know put in
the key word left before join in your
query right so what this is going to do
is it's going to instruct SQL that you
know even if
no corresponding values are found in the
table that's on the right-hand side of
the join operation you know you still
pull out values from the table that's on
the left-hand side of the join operation
in this case that you toriel that table
is the tutorial table right so it
appears before the join keyword so
that's why it's on the left side and
when you execute this query you see now
that we do get the subject Microsoft
Excel in the results side although we
don't see any values for total views or
total likes you know in in in those two
columns because well data is not present
in the tutorial risk or info table and
if you would someday put in some data in
those columns
you know what rows numbered eighteen to
twenty-two then you would see some
numbers here to put in that case what
you won't have to use the left join
operation you can use the you know
normal inner join but anyway this is all
that I had to say about the left join
operation in the next tutorial we'll
talk about the right join operation
which is pretty similar to this and you
know it's it's only you know different
in the way that you know in that case if
corresponding values are not present in
the table that's on the left-hand side
of the join operation you know but if
values are putted in the right hands in
the table that's on the right-hand side
of the join operation then you can use
the right join operation to you know get
those values in the result set but
anyway thank you so much for watching
this one and I assume the next tutorial
and you may subscribe to my channel if
you have already and as you soon