Question on right join
in SQL / 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)
Thanks for reaching out.
But in this case NULL values do not count as matching values in JOINs.
Hope this helps.