MySQL 2 left join sulla stessa tabella

[iox84]

Prova con una UNION:

(Select * from TEMP1 left join TEMP2 on TEMP1.ID2=TEMP2.ID2) UNION 
(select * from TEMP1 left join TEMP3 on TEMP1.ID3=TEMP3.ID3);