MySQL数据库中,以id字段为依据,内连接两个名为employee和salary的数据表,并查询employee数据表的name字段和salary数据表的bank字段的SQL语句是( )。(2.0)
选项:
A:SELECT employee.name, salary.bank FROM employee JOIN salary ON employee.id = salary.id;
B:SELECT employee.name, salary.bank FROM employee UNION JOIN salary ON employee.id = salary.id;
C:SELECT employee.name, salary.bank FROM employee JOIN salary ON employee.name = salary.name;
D:SELECT employee.name, salary.bank FROM employee JOIN salary ON employee.id = salary.id AND employee.name = salary.name;
发布时间:2024-04-14 21:15:07