quote:

---

Is there an advantage in putting the inequality in the join statement rather than in a WHERE clause? Does the query run faster?

example:

SELECT s.CourseID,s.SectionNumber,
c.RoomCapacity, s.SectionCapacity
FROM tb_ClassSection s
INNER JOIN tb_Classroom c
ON ( s.BuildingName = c.BuildingName
AND s.RoomNumber = s.RoomNumber)
WHERE c.RoomCapacity < s.SectionCapacity

---

quote:

---

quote:

---

Is there an advantage in putting the inequality in the join statement rather than in a WHERE clause? Does the query run faster?

example:

SELECT s.CourseID,s.SectionNumber,
c.RoomCapacity, s.SectionCapacity
FROM tb_ClassSection s
INNER JOIN tb_Classroom c
ON ( s.BuildingName = c.BuildingName
AND s.RoomNumber = s.RoomNumber)
WHERE c.RoomCapacity < s.SectionCapacity

---

That would be my questions too. Too bad there's no answer.

---