27,579
社区成员
发帖
与我相关
我的任务
分享
Select A.id,B1.addr as addr1,B2.Addr as addr2
from table1 A
left join table2 B1 on A.id_addr1=B1.ID
left join table2 B2 on A.id_addr2=B2.ID
Select A.id,B1.addr as addr1,B2.Addr as addr2
from table1 A
left join table2 B1 on A.id_addr1=B1.ID
left join table2 B2 on A.id_addr2=B2.ID