sql 1
$SQL=="select table1.* , table2.* from table1
left join table2 on (table2.id = table1.foreignkey)
where
table1.idsofmulitiple = whateveralue
and
table2.fieldsofidentity = whateveralue
";
vs
sql2
$SQL=="select table1.* , table2.* from table1
left join table2 on (table2.id = table1.foreignkey and table2.fieldsofidentity=whatevervalue)
where
table1.idsofmulitiple = whateveralue
";