1 reply to this topic

[lol33d]

Hi guys

please check this:

SELECT students.name, students.family, section.term, section.group

FROM students, section

WHERE students.id = section.id AND section.course = '234' AND term = '1' AND group = '54'

and this:

SELECT students.name, students.family, section.term, section.group

FROM students

INNER JOIN section

ON students.id = section.id

WHERE section.course = '234' AND term = '1' AND group = '54'

what is better query?

thank you

[Vaielab]

The second one, with the inner join.

The first query will join every row of student with every row of section, and then remove the one he don't need.

The second query will join only the one that are linked together and than do the where, so he will have less data to manipulate