# 子查询(嵌套查询)
# 完整sql执行顺序:
# from -> where -> group by -> having -> select -> order by -> limit
# 方法1:数据是两个表共同的数据,确定是内连接 inner
SELECT e.last_name,e.first_name,d.dept_no
FROM employees AS e
INNER JOIN dept_emp AS d
ON e.emp_no=d.emp_no;
#方法2:笛卡尔积
# SELECT e.last_name,e.first_name,d.dept_no
# FROM employees AS e,dept_emp AS d
# WHERE e.emp_no = d.emp_no
# 方法3:
# Select employees.last_name,employees.first_name,dept_emp.dept_no
# From employees,dept_emp
# Where employees.emp_no = dept_emp.emp_no;