-
-
-
-
-
select employee_id,department_name from employees e,departments d where e. department_idd.department...0240
-
-
-
-
-
-
-
查询员工ID和部门ID SQL92 内连接SELECT e.employee_id,d.department_idFROM employees e, departments dWHERE e.depa...0251 -
查询员工id和部门名 106SELECT employee_id,department_name FROM employees e,departments d WHERE e.department_...0226
-
-
-
-
0219
-
SQL92内连接： SELECT employee_id,department_name FROM employees e,departments d WHERE e.department_id d...0269
-
-
-
SQL有两个语法规范 SQL92 SQL99 SQL92的内连接 SELECT employee_id,department_name FROM employees e,departments d ...0268
-
SQL92内连接 SELECT e.employee_id,d.department_name from employees e,departments d where e.department_id...0274
-
-
内连接 在之前写的一般都是内连接 如果想把除了内连接的显示出来，还想把其他的内容显示出来，即为外连接 外连接分为左外连接，右外连接和满外连接 外连接一般有两种语法规范 SQL92 SQL99 ...0285
-
-
-
-
-
-
