FROM `tbl1` t1, `tbl2` t2
WHERE t1.id=56 AND t2.id = 56
I need the values from the tables tbl1, tbl2 where the id is 56.
In tbl2 there may or may not be an id=56 - in that case I would still want the query to return tbl1's row - but that wont happen because of the AND.
So how do I return the row of tbl1 when tbl2 doesnt have such an id ?
I know to get this using 2 queries - Im looking for a single query statement.