VbzCart/docs/queries/qryCtg build: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (moved from single-page listing) |
imported>Woozle (appears to be unused) |
||
| Line 1: | Line 1: | ||
==Details== | ==Details== | ||
* '''Status''': Appears to be unused -- not found in database | |||
* '''Requires''': [[../qryCtg_build_sub|qryCtg_build_sub]] | * '''Requires''': [[../qryCtg_build_sub|qryCtg_build_sub]] | ||
* ''' | * '''History''': | ||
** '''2010-11-09''' marked as unused | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build AS | ||
Revision as of 01:56, 10 November 2010
Details
- Status: Appears to be unused -- not found in database
- Requires: qryCtg_build_sub
- History:
- 2010-11-09 marked as unused
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build AS
SELECT *, isForSale And Not IFNULL(isCloseOut,FALSE) AS isInPrint, IFNULL(ItOpt_Descr_part,NameSng) AS ItOpt_Descr FROM qryCtg_build_sub</mysql>
<section end=sql />