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)
Hi Meenakshi!
Thanks for reaching out.
Yes, your code is correct and produce the same result set.
Hope this helps.
Best,
Tsvetelin