In the selection from the dept_manager table, why did we insert a NULL AS emp_no, knowing that this field exists in both tables?

Hi Anas! Thanks for reaching out. UNION and UNION ALL could be applied to two tables that have the same structure (i.e. we could have split e.g. the 'departments' table into two, and then use UNION to combine the two parts), so we can create additional columns with NULL values for both tables, so that the "new" tables with the NULL columns would fit and thus can be combined with UNION / UNION ALL. Hope this helps. Best, Tsvetelin

Follow this topic

Anas Alkhaldi

Last answered:

18 Mar 2022

Posted on:

10 Mar 2022

In the selection from the dept_manager table, why NULL AS emp_no?

in SQL / UNION vs UNION ALL

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

18 Mar 2022

In the selection from the dept_manager table, why NULL AS emp_no?

Submit an answer

related questions