VbzCart/queries/qryOrders Pulled

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

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>