Java基础培训第12节

Mysql语句的学习

内链接
SELECT employ.id,employ.name AS ‘员工们’,department.name AS ‘部门’ FROM employ,department WHERE employ.depno=department.id;
SELECT employ.id,employ.name AS ‘员工们’,department.name AS ‘部门’ FROM employ INNER JOIN department ON employ.depno=department.id;
外连接 分为左连接和右连接
左链接
SELECT employ.id,employ.name AS ‘员工们’,department.name AS ‘部门’ FROM employ LEFT OUTER JOIN department ON employ.depno=department.id;
右连接
SELECT employ.id,employ.name AS ‘员工们’,department.name AS ‘部门’ FROM employ RIGHT OUTER JOIN department ON employ.depno=department.id;