VbzCart/docs/queries/qryOrderLines Active: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==Details== * '''Returns''': all order lines for orders which are currently active as determined by qryOrders_Active. * '''Requires''': {{vbzcart/table|ord_lines}},...) |
m (Woozle moved page VbzCart/VbzCart/queries/qryOrderLines Active to VbzCart/docs/queries/qryOrderLines Active without leaving a redirect: part 2) |
(No difference)
| |
Latest revision as of 01:55, 25 February 2024
Details
- Returns: all order lines for orders which are currently active as determined by qryOrders_Active.
- Requires: Template:Vbzcart/table, qryOrders_Active
- Used by: qryOrdItms_Pkg_qtys
- History:
- 2008-11-16 created for new restocking process
SQL
<section begin=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> <section end=sql />