复习inner join(取交集)的用法,语法格式:
Select column_name(s)
From table 1
Inner join table 2
On Table 1.column_name=table 2.column_name
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;
复习inner join(取交集)的用法,语法格式:
Select column_name(s)
From table 1
Inner join table 2
On Table 1.column_name=table 2.column_name
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;