Difference between revisions of "VbzCart/queries/qryCtg Sources active"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(moved from single-page listing)
 
(used by qryCtg_src_sub)
 
Line 1: Line 1:
 
==Details==
 
==Details==
 
* '''Requires''': [[../../tables/ctg_sources|ctg_sources]]
 
* '''Requires''': [[../../tables/ctg_sources|ctg_sources]]
−
* '''Used by''':
+
* '''Used by''': {{vbzcart/query|qryCtg_src_sub}}
 
==SQL==
 
==SQL==
 
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Sources_active AS
 
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Sources_active AS

Latest revision as of 23:51, 3 May 2009

Details

  1. REDIRECT Template:l/vc/query

SQL

<mysql>CREATE OR REPLACE VIEW qryCtg_Sources_active AS 

 SELECT *
 FROM ctg_sources AS sc
 WHERE (sc.DateAvail <= NOW()) AND (sc.ID_Supercede IS NULL);</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtg_Sources_active&oldid=11730"