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
Submit an answer
