最新话题
-
SELECT last_name,department_name FROM employees e,departments d; WHERE e.department_id d.department...0263 -
SELECT last_name,department_name FROM employees e,departments d WHERE e.department_idd.department_id...0294
-
SELECT last_name,department_name FROM employees,departments WHERE employees.department_iddepartments...0267
-
SELECT last_name,department_name from employees, departments WHERE employees.department_iddepartment...0281
-
select emp.last_name,dep.department_name from employees emp,departments dep where emp.department_idd...0297 -
SELECT first_name,department_name FROM employees,departments WHERE employees.department_iddepartment...0277
-
SELECT first_name, last_name,department_name FROM employees,departments where employees.department_i...0291
-
SELECT last_name,department_name FROM employees,departments WHERE employees.department_id departmen...0311
-
SELECT last_name,department_name from employees e,departments d WHERE e.department_idd.department_id...0277
-
SELECT last_name,department_name from employees e,departments d WHERE e.department_idd.department_id...0264
-
思考： 三张表不能合成一张表 查询员工ID和部门名称 错误示范,把每个员工和每个部门都排序一遍 SELECT employee_id,department_name FROM employees, ...0263 -
select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,.locations ...4299
-
SELECT emp.employee_id,emp.last_name,mgr.employee_id,mgr.last_name FROM employees emp,employees mgr ...0266
-
select employee_id,last_name,department_name,city from employees,departments,locations where employe...3274
-
select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locations l...1284
-
查询员工的employee_id,last_name,department_name,city select employee_id,last_name,department_name,city fr...1273
-
select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locations l...0259
-
SELECT e.employee_id,e.last_name, d.department_id,i.city FROM employees e,departments d,locations i;...0266
-
select e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locations l...0261
-
SELECT e.employee_id,e.last_name,d.department_name,l.city from employees e,departments d,locations l...0281