VbzCart/queries/qryOrderLines Active

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

Details

  • Returns: all order lines for orders which are currently active as determined by qryOrders_Active.
  • Requires:
  1. REDIRECT Template:l/vc/table, qryOrders_Active

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>