select *from a表 a inner join b表 b on a.pid=b.pidwhere a.pid=1
select * from b left join a on b.pid = a.pid where b.pid = 1
select * from a表，b表 where a表.pid=b表.pidand a表.pid=1
