INNER JOIN - I cant find the d dept_manger_dup table doesnt exisit. Where did i miss it?

in SQL / INNER JOIN - Part I

When i run my script i get the error below. im chasing time to make it before the deadline. Please help

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

23 Nov 2022

Hi Sebastian!
Thanks for reaching out.

It seems that this table does not exist. Please, first create this table, then insert the specified data and then you can use this table in the SELECT statement.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Alessandro Imbrìaco

Resolved: Can't understand what LEFT JOIN does

Sivarajan Sivakumar

Cannot insert 999903 into the dept_emp table?

Marcus Wern Han Leong

Why did you not do not null, primary key and auto increment for customer id in the solution?

Harsha Dharmabandu

Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty

Anna Znosko

Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly

lalit yadav

Resolved: M query fetch time increased after creating an index for the salaries table!

Matt Birch

Error after Error: Can't create a table this time

Snoor Salihi

Resolved: Drop table from the database