Difference between revisions of "VbzCart/queries/qryTitles ItTyps Titles"
Jump to navigation
Jump to search
(moved from single-page listing) |
(4/13: v_titles -> qryCat_Titles_Item_stats) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | ==About== | ||
| + | * '''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 7: | Line 12: | ||
t.CatNum, | t.CatNum, | ||
t.CatWeb | t.CatWeb | ||
| − | FROM qryTitles_ItTyps_grpItems AS ti LEFT JOIN | + | 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 /> | ||
Latest revision as of 11:07, 13 April 2009
About
- Requires:
- 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>