select cu.customerid 客户编号,count(distinct o.orderid) 订单数,cast(sum(od.unitprice*quantity*(1-discount)) as decimal(10,2)) 订单总额
from dbo.orders o outer join dbo.customers on o.orderid=cu.customerid outer join dbo."order details" od on od.orderid=o.customerid
group by cu.customerid
order by cu.customerid
怎样都是"outer"附近有语法错误~这究竟是怎么回事啊~望高人指点啊~谢谢~
select cu.customerid 客户编号,
count(distinct o.orderid) 订单数,
cast(sum(od.unitprice*quantity*(1-discount)) as decimal(10,2)) 订单总额from dbo.orders o
outer join dbo.customers cu on o.orderid = cu.customerid
outer join dbo."order details" od on o.customerid = od.orderidgroup by cu.customeridorder by cu.custom
