1、左查询 左表就是在 left outer join 关键字左边的表 select s.name,d.name from student s left join zhtt0_dept d on s.deptId=d.id; |
右连接 select s.name,d.name from student s right join zhtt0_dept d on s.deptId=d.id; |
全连接 select s.name,d.name from student s full join zhtt0_dept d on s.deptId=d.id; 但是MySql不支持,可以用下面语句代替 mysql> select s.name,d.name from student s left join zhtt0_dept d on s.deptId=d.id -> union -> select s.name,d.name from student s right join zhtt0_dept d on s.deptId=d.id; |