仰望星空，脚踏实地。

Query from the result of another query . basic table select * from Customers; select * from [Order Details]; select * from Orders; first query select o.CustomerID,sum(od.UnitPrice*od.Quality) as Amount

SQL-JOIN

1 all select column names must in the group by or aggregate function