VbzCart/docs/queries/qryTitles ItTyps Titles: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(revision to be done tomorrow)
m (Woozle moved page VbzCart/VbzCart/queries/qryTitles ItTyps Titles to VbzCart/docs/queries/qryTitles ItTyps Titles without leaving a redirect: part 3/5)
 
(One intermediate revision by one other user not shown)
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 01:56, 25 February 2024

About

SQL

<section begin=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> <section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryTitles_ItTyps_Titles&oldid=6833"