VbzCart/docs/queries/qryOrders Pulled

About

• Used by: Template:Vbzcart/query
• History:
  • 2009-07-10 Adapted from MS Access (replaces qryOrderPulls_active)
    • qryOrderPulls_active derived its list of pulled orders from Template:Vbzcart; qryOrders_Pulled lists all core_orders where ID_Pull is set

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryOrders_Pulled AS SELECT

 op.*

FROM core_orders AS o LEFT JOIN ord_pull AS op

 ON o.ID_Pull=op.ID

WHERE o.ID_Pull IS NOT NULL;</mysql> <section end=sql />