VbzCart/queries/qryOrders Pulled

About

• Used by:

1. REDIRECT Template:l/vc/query

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

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>