In this lesson, we refere to a duplicate of dept_manager_table name dept_manager_dup. It includes null values and some new inserted values compared to the original dept_manager table. Not sure if this was part of a previous exercise, but I don't recall having to create and modify the dept_manager_dup table. Can you show the instructions to re-create this duplicate table with the null values and new content if any? Thanks. Francois

Hi Francois! Thanks for reaching out. The duplicate table should be the same. So, the code for inserting records in the duplicate table is: INSERT INTO departments_dup ( dept_no, dept_name ) SELECT * FROM departments; Hope this helps. Best, Tsvetelin

Follow this topic

Francois Chouinard

Last answered:

15 Dec 2021

Posted on:

02 Nov 2021

Can you show the instructions to reproduce dept_manager_dup table?

in SQL / INNER JOIN - Part I

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

15 Dec 2021

Can you show the instructions to reproduce dept_manager_dup table?

Submit an answer

related questions