VbzCart/docs/queries/qryCbx RstkReq

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search

About

  • Purpose: for use in drop-down lists
  • Requires: Template:Vbzcart/query, Template:Vbzcart/query
  • 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

<section begin=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>

<section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryCbx_RstkReq&oldid=6750"