differnece between where clause and on clause in SQL join ?i want to list course name form the table course with student info.
student_id is foreign key at course table , id is primary key at student table.
i did it with join in "where clause"
select c.name from student as s , course c where c.student_id= s.id
and doing same with "on clause"
select name from student as s join course c on c.student_id= s.id
i got same result for both query.
so what is difference between where clause and on clause in SQL join , whats is pros and cons of " where clause" vs "on clause" in SQL join
currently dealing with MySQL but SQL , PostgreSQL all have same story i think,