SELECT t.*, i.fld1 AS Mfld1, i.fld2 AS Mfld2 FROM items_source t WHERE t.sid=5LEFT JOIN items_source i ON (i.id=5)