Difference between revisions of "VbzCart/queries/qryCbx RstkReq"
Jump to navigation
Jump to search
(New page: ==About== * '''Purpose''': for use in drop-down lists * '''Requires''': {{vbzcart/query|qryRstkReq_by_status}}, {{vbzcart/query|qryRstkReq_by_PurchOrd}} * '''History''': ** '''2008-12-22''...) |
m (→About: this may actually be inferior to the one I did in Access) |
||
| Line 4: | Line 4: | ||
* '''History''': | * '''History''': | ||
** '''2008-12-22''' Adapted from the [[../discarded|discarded]] query qryCbxRestock | ** '''2008-12-22''' Adapted from the [[../discarded|discarded]] query qryCbxRestock | ||
| − | * '''Notes''': MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine. | + | * '''Notes''': |
| + | ** MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine. | ||
| + | ** This version may actually be inferior to the one I created (recently) in Access. There's also a version for received restocks. | ||
| + | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_RstkReq AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_RstkReq AS | ||
Latest revision as of 19:03, 22 December 2008
About
- Purpose: for use in drop-down lists
- Requires:
- REDIRECT Template:l/vc/query, qryRstkReq_by_PurchOrd
- History:
- 2008-12-22 Adapted from the discarded query qryCbxRestock
- Notes:
- MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine.
- This version may actually be inferior to the one I created (recently) in Access. There's also a version for received restocks.
SQL
<mysql>CREATE OR REPLACE VIEW qryCbx_RstkReq AS
SELECT * FROM qryRstkReq_by_status WHERE Descr IS NOT NULL
UNION
SELECT * FROM qryRstkReq_by_PurchOrd WHERE Descr IS NOT NULL;</mysql>