VbzCart/docs/queries/qryRstkItms unsent

About

• Returns: items from restock requests which have not yet been submitted to the supplier
• Requires: Template:Vbzcart/table, Template:Vbzcart/query
• Used by:
• History:
  • 2008-12-04 Created for new restock process

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkItms_unsent_for_order AS SELECT

 rqi.*

FROM

 rstk_req_item AS rqi LEFT JOIN qryRstks_unsent AS rq ON rqi.ID_Restock=rq.ID;