VbzCart/queries/qryTitleTopic Titles

About

• Returns: titles x topics with complete Title data
• Used by: Topic pages
• Requires: brs_titles_x_topics, cat_titles
• History:
  • 2011-01-24 created for Title listing on Topic pages

SQL

<mysql>CREATE OR REPLACE VIEW qryTitleTopic_Titles AS

 SELECT tt.ID_Topic, t.*
 FROM brs_titles_x_topics AS tt
 LEFT JOIN cat_titles AS t
 ON tt.ID_Title=t.ID;</mysql>