VbzCart/queries/qryCbx CustNames

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

  • Purpose: Provides a list of customer names with associated cust_name IDs
  • Requires: cust_names
  • Used by:
  1. REDIRECT Template:l/vc/query
  • History:
    • 2009-07-09 Copied from MS Access version

SQL

<mysql>CREATE OR REPLACE VIEW qryCbx_CustNames AS SELECT

 ID,
 Name

FROM cust_names ORDER BY Name;</mysql>