Two tables or Three tables?

Question

It seems that three tables were used in the video: employees, dept_manager and dept_emp.
Both dept_manager and dept_emp has same column names.
In my query I used employees and dept_emp tables
(SELECT
                    emp_no
                FROM
  dept_emp de <--- Here I didn't used dept_manager
                WHERE
                    emp_no = 110022) AS manager_ID

Answer 1

Hi Amy!
Thanks for reaching out.

In this particular case you can use the dept_emp table instead of the dept_manager table. Your solution is fine.

Hope this helps.
Best,
Tsvetelin

Two tables or Three tables?

Submit an answer

related questions