给定查询语句: SELECT a.name, a.salary, b.deptname FROM tb_emp a, tb_dept b WHERE a.deptno=b.deptno; 下列查询语句中与之等价的是
A.
SELECT a.name, a.salary, b.deptname FROM tb_emp a inner join tb_dept b ON a.deptno=b.deptno;
B.
SELECT a.name, a.salary, b.deptname FROM tb_emp a left outer join tb_dept b ON a.deptno=b.deptno;
C.
SELECT a.name, a.salary, b.deptname FROM tb_emp a right outer join tb_dept b ON a.deptno=b.deptno;
D.
SELECT a.name, a.salary, b.deptname FROM tb_dept b left outer join tb_emp aON a.deptno=b.deptno;