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';

Hi Meenakshi! Thanks for reaching out. Yes, your code is correct and produce the same result set. Hope this helps. Best, Tsvetelin

Follow this topic

Last answered:

16 Dec 2021

Posted on:

06 Nov 2021

Regarding assignment on joining more than two tables:

1 answers ( 0 marked as helpful)

Instructor

Posted on:

16 Dec 2021