单项选择题

Employee的表结构为:职工号、单位号、工资,Department 的表结构为:单位号、单位名称、人数,与下列语句等价的SQL命令是SELECT 职工号,单位名称 FROM Employee,Department ;WHERE 工资>12000 AND Employee.单位号=Department.单位号

A.SELECT 职工号, 单位名称 FROM Department JOIN INNER employee ON Department.单位号 = Employee.单位号 WHERE Employee.工资 > 12000
B.SELECT 职工号, 单位名称 FROM Department INNER JOIN employee ON Department.单位号 = Employee.单位号 WHERE Employee.工资 > 12000
C.SELECT 职工号, 单位名称 FROM Department JOIN INNER employee Department.单位号 = Employee.单位号 WHERE Employee.工资 > 12000
D.SELECT 职工号, 单位名称 FROM Department INNER JOIN employee ON Department.单位号 = Employee.单位号 Employee.工资 > 12000