注意：此页面搜索的是所有试题
题目内容
（河南财经政法大学SQL Server）
在SqlServer的示例数据库NorthWind中，你想获得一张包含lastName和orderDate的列表，，该列表中的雇员至少要处理过一份订单。下面的T-SQL都可以实现该要求，除了
A.select employees.lastname,orders.orderdate from employees left join orders on employees.employeeid=orders.employeeid
B.select employees.lastname,orders.orderdate from employees join orders on employees.employeeid=orders.employeeid
C.select employees.lastname,orders.orderdate from employees inner join orders on employees.employeeid=orders.employeeid
D.select employees.lastname,orders.orderdate from employees,orders where employees.employeeid=orders.employeeid
A.select employees.lastname,orders.orderdate from employees left join orders on employees.employeeid=orders.employeeid
B.select employees.lastname,orders.orderdate from employees join orders on employees.employeeid=orders.employeeid
C.select employees.lastname,orders.orderdate from employees inner join orders on employees.employeeid=orders.employeeid
D.select employees.lastname,orders.orderdate from employees,orders where employees.employeeid=orders.employeeid
参考答案