SQL Tutorial - 32: Right Outer JOIN Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 30 second tutorial in this course
and in this tutorial we are going to
talk about the right join operation and
you know I have added some rows in the
tutorial underscore info table and
corresponding rows in the tutorial table
are not there right so let me just show
you guys the data that I have in the
tutorial underscore info table first
tutorial underscore info and when I
execute the query you would see that I
have a rows that have values 23 24 and
25 for the tutorial underscore ID column
and if I would show you the data that's
there in the tutorial table you would
see that there are no rows that have you
no value for the ID column you know
between 23 and 25 right so if suppose I
want to pull out information from both
tables for all rows that are present in
the T Tauri underscore info table even
if you know no corresponding rows are
present in the tutorial table then in
that case if I have to modify this query
you know the one that we executed in the
last tutorial you know when we discussed
left join if I have to modify this query
and if I have to make some adjustments
to you know getting data from Tottori
underscore info table for rows with ID
23 24 or 25 then I have to you know take
out the left keyword from there and type
in right instead right and that's
because the tutorial underscore info
table in this query happens to be on the
right hand side off the join keyword
right and when I would execute this
query I would see that I get you know
some values for total views in total
likes you know four one five eight five
zero and 2619 for a subject that you
know is is not present in the tutorial
table and that's why it's displayed as
null here right so it's a null value it
does you know these values do not have a
corresponding match in the tutorial
table but still since we're using the
right join operation you know we are
getting a row with the these values
displayed you know with corresponding
null match right so that's it about
joins and you know there is actually one
more
kind of joint operation that I wanted to
discuss in this course and that's the
full outer join operation but then you
know MySQL does not support full outer
join and you know I thought first about
it that maybe I should you know show you
full outer join in Microsoft sequel
server environment through the SQL
Server management studio interface but
then I thought that that would be too
much work and you know I mean there's
actually a way around the full auto join
in MySQL where you can have a union of
the right and left outer joins but
that's something that we might discuss
later on in this course or maybe in some
other playlist that I record in the
future but you don't have to worry about
that too much you know if you if you
understood as much about joins as we
discussed in this course and you're good
to go and thank you so much for watching
this one in the next tutorial we are
going to begin discussion you know begin
our discussion on numeric functions in
MySQL and that's going to be very
interesting so I'll see you in the next
tutorial and thank you so much for
watching this and you may subscribe to
my channel if you haven't already and
bye bye