VbzCart/queries/qryOrderLines Active

Details

 * Returns: all order lines for orders which are currently active as determined by qryOrders_Active.
 * Requires:, qryOrders_Active
 * Used by: qryOrdItms_Pkg_qtys
 * History:
 * 2008-11-16 created for new restocking process

SQL
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;