请看下表：
Customers
- - - - - - - -
Customerid
Customername
Address
////////////////////////////////////
Orders
- - - - -
Orderid
Customerid
Orderdate
Comments
要获取每个客户所下订单的客户名称和第一个订单日期，应如何查询？ ( )
Select Customers.Customername,(Select Min(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers
Select Customers.Customername,(Select Max(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers
Select Customers.Customername,(Select Orderdate From Orders Where Customers.Customerid=Orders.Customerid) From Customers
Select Customers.Customername,Min(Orders.Orderdate) From Orders,Customers Where Customers.Customerid=Orders.Customerid
都不对
