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.
titles t ON e.emp_no = t.emp_no
dept_manager m ON t.emp_no = m.emp_no
departments d ON m.dept_no = d.dept_no
1 answers ( 0 marked as helpful)
Thanks for reaching out.
Yes, your code is correct and produce the same result set.
Hope this helps.
Submit an answer
The schema section does not show the tables in the Tables subsection.
Resolved: unable to download resources that are related to the only the assignment sections!