Difference between revisions of "VbzCart/queries/qryCtg Sources active"
Jump to navigation
Jump to search
(moved from single-page listing) |
(No difference)
|
Revision as of 19:29, 30 November 2008
Details
- Requires: ctg_sources
- Used by:
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>