mysql数据库-关联表查询
1.内连接查询
inner join on
select * from tbname,tbname1 where tbname.id = tbname1.id;
//等同于==
select * from tbname inner join tbname1 on tbname = tbname1.id;//效率相对较高
2.左外连查询
显示左表tbname中的所有行,并把右表tbname1中符合条件加到左表tbname中;右表tbname1中不符合条件,就不用加入结果表中,并且NULL表示。
left join on
SELECT * FROM tbname LEFT JOIN left_tablename ON tbname.id =left_tablename .id;
3.右外连查询
显示右表tbname1中的所有行,并把左表tbname中符合条件加到右表tbname1中;左表tbname中不符合条件,就不用加入结果表中,并且NULL表示。与左联相反!
right join on
SELECT * FROM tbname RIGHT JOIN right_tbname ON right_tbname.id = tbname .id;
join on...最好记的就是语法了.