Question on right join
From the above when we do the right join using dept_no, even though we are having matching row "null", why it's not showing in the joined table? i.e if we want to see emp_no's 999904,05,06,07
.
1 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Hi Akash!
Thanks for reaching out.
But in this case NULL values do not count as matching values in JOINs.
Hope this helps.
Best,
Tsvetelin