MySQL query from two tables

[kobbe]

Need help with a query:

SELECT a.id, b.id FROM t1 AS a, t2 AS b WHERE a.id=123 AND b.id=a.id;

This only works if there is a b.id that matches a.id... but what to write if I want it to work even if b.id are missing ?

I want it to get all id from A and only id from B if there is a matching id.

Sry for my bad english, hope you understand my question.

Regards

[OhLordy]

LEFT JOIN
SELECT t1.id as t1_id, t2.id as t2_id FROM t1 LEFT JOIN t2 on (t1.id=t2.id) where t1.id=123;

HTH
Rob