VbzCart/docs/queries/qryStk lines remaining forSale

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Revision as of 23:02, 29 November 2009 by imported>Woozle (updated because of name-change in underlying query)
Jump to navigation Jump to search

Details

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining_forSale AS

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

<section end=sql />