RE: [PHP] php - mysql problem

[snip] $sql = "SELECT * FROM table1 LEFT JOIN table2 USING id WHERE ... GROUP BY table1.id"; mysql_query($sql); the problem is, that, when in table2 is not matching data using that id, i lose that id from output array. but i don`t want to.. is there any posibility to keep that id? [/snip] More of a mysql question but do a left outer join with no group by statement. SELECT table2.* FROM table1 LEFT OUTER JOIN table2 ON(table1.id = table2.id) WHERE table1.id IS NULL Returns all of table2 id's where there is no id in table1