Resolved: Join and where used together

He said that its consider a good practice to include the column that act as a connection point between the tables (which is emp_no column from employees and salaries tables in this case ), and the column that show the condition of where clause (which is salary column from salaries table).

because you could only select (first_name, last_name) columns from first table and still get the same result.

Hi Fatma and Ahmed!
Thanks for reaching out.

@: Ahmed
Thanks for sharing this piece of information with the Community!

@: Fatma

As Ahmed said the instructor said that its considered a good practice to include the column which joins the tables and the one used in the WHERE clause.

Hope this helps.
Best,
Tsvetelin

Thank you both for your help.