Difference between revisions of "VbzCart/queries/qryTitleTopic Topics"
Jump to navigation
Jump to search
(Created page with "==About== * '''Returns''': titles x topics with complete Topic data * '''Used by''': Title pages * '''Requires''': {{vbzcart|table|brs_titles_x_topics}}, {{vbzcart|table|brs_topi...") |
(table names changed) |
||
| Line 5: | Line 5: | ||
* '''History''': | * '''History''': | ||
** '''2011-01-24''' created for Topic listing on Title pages | ** '''2011-01-24''' created for Topic listing on Title pages | ||
| + | ** '''2011-09-28''' renamed brs_* to cat_* (singular) for consistency | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitleTopic_Topics AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitleTopic_Topics AS | ||
SELECT tt.ID_Title, t.* | SELECT tt.ID_Title, t.* | ||
| − | FROM | + | FROM cat_title_x_topic AS tt |
| − | LEFT JOIN | + | LEFT JOIN cat_topic AS t |
ON tt.ID_Topic=t.ID;</mysql> | ON tt.ID_Topic=t.ID;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Latest revision as of 23:21, 28 September 2011
About
- Returns: titles x topics with complete Topic data
- Used by: Title pages
- Requires: brs_titles_x_topics, brs_topics
- History:
- 2011-01-24 created for Topic listing on Title pages
- 2011-09-28 renamed brs_* to cat_* (singular) for consistency
SQL
<mysql>CREATE OR REPLACE VIEW qryTitleTopic_Topics AS
SELECT tt.ID_Title, t.* FROM cat_title_x_topic AS tt LEFT JOIN cat_topic AS t ON tt.ID_Topic=t.ID;</mysql>