Tags
,
Asked 30+ days ago
20 Dec 2016
Views 103
jaman

jaman posted

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,
Post Answer