select a.*,b.* from a c left join b d on c.id=d.aid
select * from a表 inner join b表 on a表.id=b表.aid;
select c.*,d.* from a as c left join b as d on c.id=d.aid
左联,右联,总之就是连接查询select * from a表 inner join b表 on a表.id=b表.aid;
select a.id,a.name,a.sex,a.phone,b.id,b.titles,b.onclicks,b.contens,b.aid from a as a inner join b as b on a.id=b.aid
select tablea.id,tablea.name,tablea.sex,tablea.phone,tableb.id, tableb.titles,tableb.onclicks,tableb.contens from a tablea inner join b tableb on tablea.id=tableb.aid
select a.*,b.* from a c left join b d on c.id=d.aid
select c.*,d.* from a as c left join b as d on c.id=d.aid
select a.id,a.name,a.sex,a.phone,b.id,b.titles,b.onclicks,b.contens,b.aid from a as a
inner join b as b on a.id=b.aid
tableb.titles,tableb.onclicks,tableb.contens
from a tablea
inner join b tableb
on tablea.id=tableb.aid