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 .

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

Follow this topic