VbzCart/queries/qryOrders Pulled

About

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

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