VbzCart/queries/qryItms open
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Details
- Returns: Same rows as
- REDIRECT Template:l/vc/query but GROUPed by ID_Item
- Requires: qryOrdItms_open
- Used by:
- History:
- 2008-11-18 created for new restocking process
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>