超市商品销售关系数据库CRM有4个关系关系模式如下所示：①商品库存表：InventoryCommodityno Commodityname Price Num Address Supno主键：Commodityno其中：Commodityno Commodityname Price Num Address Supno中文含义分别为商品号商品名单价库存数量产地供货商号。②供货商表：SupplierS

CREATE PROCEDURE sp_pro_info1 @memberno VARCHAR(20) AS BEGIN SELECT Membername, Commodityno, Commodityname, Price, Salesnum, Price*Salesnum AS Amount, Supname, Telephone FROM Member JOIN Sales ON Member.Memberno = Sales.Memberno JOIN Inventory ON Sales.Commodityno = Inventory.Commodityno JOIN Supplier ON Inventory.Supno = Supplier.Supno WHERE Member.Memberno = @memberno END

注：上述存储过程用于查询指定会员号的会员名和该会员所购买商品的商品号、商品名、单价、数量、金额、商品的供货商名与电话。其中，Member表与Sales表通过Memberno关联，Sales表与Inventory表通过Commodityno关联，Inventory表与Supplier表通过Supno关联。查询条件为Memberno=@memberno