Last answered:

16 Dec 2021

Posted on:

06 Nov 2021

0

Regarding assignment on joining more than two tables:

Hi there! Could you please verify if this query is correct is correct for the given assignment question as my answer is not matching with the solution provided. Please do suggest me if I could enhance this code in some way.



SELECT
    e.first_name,
    e.last_name,
    e.hire_date,
    t.title,
    t.from_date,
    d.dept_name
FROM
    employees e
        JOIN
    titles t ON e.emp_no = t.emp_no
        JOIN
    dept_manager m ON t.emp_no = m.emp_no
        JOIN
    departments d ON m.dept_no = d.dept_no
    where t.title='manager';

1 answers ( 0 marked as helpful)
Instructor
Posted on:

16 Dec 2021

0

Hi Meenakshi!
Thanks for reaching out.

Yes, your code is correct and produce the same result set.

Hope this helps.
Best,
Tsvetelin

Submit an answer