Question

我已经提出一个分局问题,我确信这是一个真正简单的解决办法,但我可以说出什么!

Here s what I m trying to do, I have two tables, let s say, customer and orders. The customer table obviously stores a list of individual customers and the orders table stores a list of orders placed by clients. I am trying to create a query that will return each customer s details as well as the total order amount placed by that customer. Try as I might I can t seem to be able to get this query to work as it says:

“你已写出一个分局,可以在不使用从条款主要询问中保留的措辞的情况下返回一个以上的领域。”

我正试图这样做,请任何人就什么错提出建议?

select
  customer.name,
  customer.address,
  (select sum(order.orderamount) from order, customer where order.customerid = customer.id)
from
  customer

THanks!

Answer 1

select 
  customer.name, 
  customer.address, 
  (select sum(order.orderamount) from order where order.customerid = customer.id) as amount
from customer

但是,你可以这样做:

select 
  customer.name, 
  customer.address, 
  sum(order.orderamount) 
from order 
   join customer on order.customerid = customer.id
group by   customer.name,   customer.address

友情链接