syntax goes something like that:

SELECT * FROM firsttable LEFT JOIN secondtable ON firsttable.keyfield = secondtable.keyfield