![](https://cos-cdn.shuashuati.com/pipixue-web/2020-1231-2005-12/ti_inject-812ce.png)
在 SQL Server200 8 数据库中 , 客户表 customers 包含字段 : 客户编号 cid 和名称 cname, 订单表 orders 包含字段 : 客户编号 cid, 如果需要通过查询获得有订单的客户的名称,下面查询语句中 ( ) 可以实现该需求 . ( 选择一项 ) A. SELECT customers.cname from customers LEFT JOIN orders ON customers.cid = orders.cid B. SELECT customers.cname from customers INNER JOIN orders ON customers.cid = orders.cid C. SELECT customers.cname from customers RIGHT JOIN orders where customers.cid = orders.cid D. SELECT customers.cname from customers JOIN orders WHERE customers.cid = orders.cid