VbzCart/queries/qryStk lines remaining forSale

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 02:08, 4 December 2008 by Woozle (talk | contribs) (New page: ==Details== * '''Requires''': {{vbzcart/query|v_stk_lines_remaining}} * '''Used by''': {{vbzcart/query|qryStkItms_for_sale}} * '''Note''': Eventually rename as "qryStkLines_for_sale" ==SQL...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Details

  • Requires:
  1. REDIRECT Template:l/vc/query

SQL

<mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining_forSale AS

 SELECT *
 FROM v_stk_lines_remaining
 WHERE QtyForSale>0;</mysql>