VbzCart/queries/qryCtgCk dup keys

About

 * Purpose: Verification of ctg build
 * Requires: ,
 * Used by: catalog building - verification stage
 * Returns: any duplicate IDS_Items (ID_Title + CatSfx) found in currently active titles in . When this happens, it is probably due to old records whose CatSfx fields weren't set (or weren't set properly) being (re)activated by being found in stock

SQL
CREATE OR REPLACE VIEW qryCtgCk_dup_keys AS SELECT i.CatNum, i.isInPrint, u.* FROM ctg_upd2 AS u LEFT JOIN cat_items AS i ON u.ID_Item=i.ID WHERE cntDups and u.isForSale;