getting error that employees.department_dup' doesn't exist.
I have run the same code as you run in video but getting the above mention error.
please guide me
insert into department_dup
(
dept_no,
dept_name
)
select
*
from
departments;
1 answers ( 0 marked as helpful)
Hi Chetan!
Thanks for reaching out.
It seems that you are trying to insert data in a table which is not being created yet. Please, first create the departments_dup table and then proceed with the insertion. Thank you.
Hope this helps.
Best,
Tsvetelin