lriss的博客

今天讲了多表子查询，通过例子大致了解了多表查询的方法。 select e.id,e.name as ‘员工名’,d.name as ‘部门’ from employee e left outer join department d on e.depno =d.id; create table depart ( depno int primary key, name varchar(50), loc...