mysql联合查询

内联接:

select * from table1 inner join table2 on table1.field=table2.field;

左联接:
select * from table1 left join table2 on table1.field=table2.field;

右联接:
select * from table1 right join table2 on table1.field=table2.field;