Is this solution okay-gives the same output

in SQL / JOIN more than two tables in SQL

SELECT
    e.first_name,
    e.last_name,
    e.hire_date,
    t.title,
    m.from_date as start_date
FROM
    employees e
        JOIN
    dept_manager m ON e.emp_no = m.emp_no
        JOIN
    titles t ON e.emp_no = t.emp_no
    where t.title = 'Manager'
;

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

31 Aug 2022

Hi Awshesh!
Thanks for reaching out.

Yes, this solution works also. You used the titles table and in the WHERE clause you used the needed filter for managers.

Hope this helps.
Best,
Tsvetelin

Is this solution okay-gives the same output

Submit an answer

related questions