Use two left joins, i.e. something like

select from table A left join table b on a.id=b.id left join table c on a.id=c.id.

This will result in null-values for the non-matching records in tables b and c.

Regards,

Auke