select * from
(select employeeid,sum(total) from
(select orderid,sum(unitprice*quantity)as total from [order details]
group by orderid
)as a
inner join [orders]
on orders.orderid=a.orderid
group by employeeid )as b
inner join [employees]
on employees.employeeid=b.employeeid
)总提示没有给b所指定的列赋值,请问是什么问题
(select employeeid,sum(total) from
(select orderid,sum(unitprice*quantity)as total from [order details]
group by orderid
)as a
inner join [orders]
on orders.orderid=a.orderid
group by employeeid )as b
inner join [employees]
on employees.employeeid=b.employeeid
)总提示没有给b所指定的列赋值,请问是什么问题
--貌似多了最后一个)
select * from
(select employeeid,sum(total) from
(select orderid,sum(unitprice*quantity)as total from [order details]
group by orderid
)as a
inner join [orders]
on orders.orderid=a.orderid
group by employeeid )as b
inner join [employees]
on employees.employeeid=b.employeeid
(select employeeid,sum(total)as money from
(select orderid,sum(unitprice*quantity)as total from [order details]
group by orderid
)as a
inner join [orders]
on orders.orderid=a.orderid
group by employeeid )as b
inner join [employees]
on employees.employeeid=b.employeeid这样就OK啦,