VbzCart/queries/qryTitleTopic Titles

About

 * Returns: titles x topics with complete Title data
 * Used by: Topic pages
 * Requires: ,
 * History:
 * 2011-01-24 created for Title listing on Topic pages
 * 2011-09-28 source table renamed (brs_titles_x_topics -> cat_title_x_topic)

SQL
CREATE OR REPLACE VIEW qryTitleTopic_Titles AS SELECT tt.ID_Topic, t.* FROM cat_title_x_topic AS tt LEFT JOIN cat_titles AS t  ON tt.ID_Title=t.ID;