Why do we have to use a where caluse in the query to filter only managers? Since we are using inner join between managers table and other tables the query should by defualt give values only for managers right !

Hi Barun!Thanks for reaching out. Actually, this is a very good question. Bravo! This is because some of these managers which are presented in the dept_manager table have worked other positions like Staff and Senior Staff. This is why we need to use the WHERE clause in order to filter only the title Manager. You can check the same query without the WHERE clause and you will obtain 54 rows. Hope this helps.Best,Tsvetelin

Follow this topic

Barun Dev Pradhan

Last answered:

13 Mar 2023

Posted on:

12 Mar 2023

Resolved: Where clause in the assignment.

in SQL / JOIN more than two tables in SQL

1 answers ( 1 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

13 Mar 2023

Helpful answer

Resolved: Where clause in the assignment.

Submit an answer

related questions