Difference between revisions of "VbzCart/queries/qryCbx CustNames"
Jump to navigation
Jump to search
(New page: ==About== * '''Purpose''': Provides a list of customer names with associated cust_name IDs * '''Requires''': {{vbzcart|table|cust_names}} * '''Used by''': {{vbzcart/query|qryPkgs_Pull_stat...) |
(No difference)
|
Latest revision as of 19:13, 9 July 2009
About
- Purpose: Provides a list of customer names with associated cust_name IDs
- Requires: cust_names
- Used by:
- 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>