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)
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