select a.*,(select table1 .name from table1 where table1.id=a.table1ID) from table as a
select a.*,b.* from table as a,table1 as b where a b.id=a.table1ID
select a.* ,b.* from table as a left join table1 as b on b.id=a.table1ID
原文：https://www.cnblogs.com/hongmaju/p/9252185.html