difference on two queries which is better in terms of performance

difference on two queries which is better in terms of performance

Misha Singh View Member Profile	Nov 3 2009, 04:32 PM Post #1
Advanced Member Group: Members Posts: 8,266 Joined: 23-November 08 Member No.: 6,521	sql 1 PHP Code: $SQL=="select table1.* , table2.* from table1 left join table2 on (table2.id = table1.foreignkey) where table1.idsofmulitiple = whateveralue and table2.fieldsofidentity = whateveralue "; vs sql2 PHP Code: $SQL=="select table1.* , table2.* from table1 left join table2 on (table2.id = table1.foreignkey and table2.fieldsofidentity=whatevervalue) where table1.idsofmulitiple = whateveralue ";