新建 文本文档.txt

来自「网上购物系统,相信看后会有很大收获,用java,jsp,servlet编写」· 文本 代码 · 共 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'