VbzCart/queries/qryOrderLines Active
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: all order lines for orders which are currently active as determined by qryOrders_Active.
- Requires:
- REDIRECT Template:l/vc/table, qryOrders_Active
- Used by: qryOrdItms_Pkg_qtys
- History:
- 2008-11-16 created for new restocking process
SQL
<mysql>CREATE OR REPLACE VIEW qryOrderLines_Active AS SELECT ol.* FROM ord_lines AS ol LEFT JOIN qryOrders_Active AS o ON ol.ID_Order=o.ID WHERE o.ID IS NOT NULL;</mysql>