-
-
-
查询员工id和部门名字 select employee_id,last_name from employees,departments where employees.department_id de...0265
-
-
-
-
-
-
-
select employee_id,department_name from employees e,departments d where e. department_idd.department...0263
-
-
-
-
-
-
-
查询员工ID和部门ID SQL92 内连接SELECT e.employee_id,d.department_idFROM employees e, departments dWHERE e.depa...0279 -
查询员工id和部门名 106SELECT employee_id,department_name FROM employees e,departments d WHERE e.department_...0244
-
-
-
-
0233
-
SQL92内连接： SELECT employee_id,department_name FROM employees e,departments d WHERE e.department_id d...0296
-
-
-
SQL有两个语法规范 SQL92 SQL99 SQL92的内连接 SELECT employee_id,department_name FROM employees e,departments d ...0297
-
SQL92内连接 SELECT e.employee_id,d.department_name from employees e,departments d where e.department_id...0300
-
-
内连接 在之前写的一般都是内连接 如果想把除了内连接的显示出来，还想把其他的内容显示出来，即为外连接 外连接分为左外连接，右外连接和满外连接 外连接一般有两种语法规范 SQL92 SQL99 ...0313
-
