这样试试:
select man_id,man_name,
(select jc1_id,jc1_name from jc1 where jc1_id=a.jc1_id),
(select jc2_id,jc2_name from jc2 where jc2_id=a.jc2_id)
from man a
select man_id,man_name,
(select jc1_id,jc1_name from jc1 where jc1_id=a.jc1_id),
(select jc2_id,jc2_name from jc2 where jc2_id=a.jc2_id)
from man a
FROM (man
LEFT join jc1 ON man.jc1_id=jc1.jc1_id)
LEFT join jc2 ON man.jc2_id=jc2.jc2_id
少了()