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'