VbzCart/queries/qryRstkReq Item status

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

Details

  • Returns: Information about items Restock Requested and how many have been Received
  • Status: possibly no longer in use (2010-01-04), unless it turns out to be faster this way
  • Requires:
  1. REDIRECT Template:l/vc/table,
  2. REDIRECT Template:l/vc/query

SQL

<mysql>CREATE OR REPLACE VIEW qryRstkReq_Item_status AS SELECT

 rci.*,
 IFNULL(rqi.QtyExp,rqi.QtyOrd) AS QtyExp,
 rqi.Notes

FROM

   rstk_req_item AS rqi
 LEFT JOIN qryRstkReq_Item_Rcd_status AS rci ON (rqi.ID_Restock=rci.ID_RstkReq) AND (rqi.ID_Item=rci.ID_Item)

WHERE rci.ID_RstkReq IS NOT NULL ORDER BY rci.ID_RstkReq, rci.ID_Item;</mysql>