Resolved: Join and where used together
I couldn't understand the part in the video from minute 1:51 to 2:19
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.
Thanks for sharing this piece of information with the Community!
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
Hope this helps.