e****2 发帖数: 2723 | 1 最近我写的数据库CODE
与民共享
Create view vw_order_cost as
Select o.orderid,o. orderdate, d.productid, c.companyname, (d.Quantity
* d.UnitPrice) as cost from orders o join orderdetails d on o.orderid=d.
orderid
Join customers c on o.customerid=c.customerid |
|