摘要：select A.id, B.name as Name1, C.name as Name2, D.name as Name3from (select * from table2 where id='11111') A left join table1 B on A.id1=B.id left join table1 C on A.id2=B.id left join table1 D on A.i... 阅读全文