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