VbzCart/docs/queries/qryItms open

Details

• Returns: Same rows as Template:Vbzcart/query but GROUPed by ID_Item
• Requires: Template:Vbzcart/query
• Used by:
• History:
  • 2008-11-18 created for new restocking process

SQL

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

 ID_Item,
 SUM(oio.QtyOrd) AS QtyOrd,
 SUM(oio.QtySent) AS QtySent,
 SUM(oio.QtyDone) AS QtyDone,
 SUM(oio.QtyOpen) AS QtyOpen

FROM qryOrdItms_open AS oio GROUP BY ID_Item;</mysql> <section end=sql />