Difference between revisions of "VbzCart/queries/qryTitles ItTyps Titles"

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
(revision to be done tomorrow)
(4/13: v_titles -> qryCat_Titles_Item_stats)
 
Line 1: Line 1:
 
==About==
 
==About==
−
* '''Requires''': {{vbzcart/query|qryTitles_ItTyps_grpItems}}, {{vbzcart/query|v_titles}}
+
* '''Requires''': {{vbzcart/query|qryTitles_ItTyps_grpItems}}, {{vbzcart/query|qryCat_Titles_Item_stats}}
 +
* '''Used by''': catalog department pages
 +
* '''History''':
 +
** '''2009-04-13''' v_titles -> qryCat_Titles_Item_stats
 
==SQL==
 
==SQL==
 
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_Titles AS
 
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_Titles AS
Line 9: Line 12:
 
   t.CatNum,
 
   t.CatNum,
 
   t.CatWeb
 
   t.CatWeb
−
FROM qryTitles_ItTyps_grpItems AS ti LEFT JOIN v_titles AS t ON ti.ID_Title=t.ID_Title;</mysql>
+
FROM qryTitles_ItTyps_grpItems AS ti LEFT JOIN qryCat_Titles_Item_stats AS t ON ti.ID_Title=t.ID_Title;</mysql>
 
<section end=sql />
 
<section end=sql />
−
 
−
'''TO BE REVISED''' to something like this (except this doesn't work):
 
−
SELECT
 
−
  ti.*,
 
−
  t.Name,
 
−
  t.ID_Dept,
 
−
  t.CatNum,
 
−
  t.CatWeb
 
−
FROM qryTitles_ItTyps_grpItems AS ti LEFT JOIN qryCat_Titles_Item_stats AS t ON ti.ID_Title=t.ID_Title;
 

Latest revision as of 11:07, 13 April 2009

About

  • Requires:
  1. REDIRECT Template:l/vc/query, qryCat_Titles_Item_stats
  • Used by: catalog department pages
  • History:
    • 2009-04-13 v_titles -> qryCat_Titles_Item_stats

SQL

<mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_Titles AS SELECT 

 ti.*,
 t.Name,
 t.ID_Dept,
 t.CatNum,
 t.CatWeb

FROM qryTitles_ItTyps_grpItems AS ti LEFT JOIN qryCat_Titles_Item_stats AS t ON ti.ID_Title=t.ID_Title;</mysql>

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