新建 文本文档.txt

来自「实现了网上购物系统的主要功能。包括购物车和订单处理等功能。」· 文本 代码 · 共 5 行

select product.productid as productid,
  product.name as name,item.listprice as listprice,
  item.unitcost as unitcost,item.itemid as itemid,
  item.supplier as supplier from product as product,
  item as item where product.category='A' and product.productid=item.productid and item.status='1'