![](https://cos-cdn.shuashuati.com/pipixue-web/2020-1231-2005-12/ti_inject-812ce.png)
客户表customers包含字段:客户编号cid和名称cnaie,订单表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