employee 的表结构为:职工号、单位号、工资, department 的表结构为:单位号、单位名称、人数,与下列语句等价的 SQL 语句是 ____________ 。 Select 职工号,单位名称 from employee, department; Where 工资 >12000and employee. 单位号 =department. 单位号
A.
Select 职工号, 单位名称 from department inner join employee on employee.单位号=department.单位号 Where employee.工资>12000
B.
Select 职工号, 单位名称 from department inner join employee on employee.单位号=department.单位号 employee.工资>12000
C.
Select 职工号, 单位名称 from department join inner employee employee.单位号=department.单位号 Where employee.工资>12000
D.
Select 职工号, 单位名称 from department join inner employee on employee.单位号=department.单位号 Where employee.工资>12000