VbzCart/queries/qryCtg Items active

Details

 * Purpose: Brings up only ctg_items records which are active, simplifying the final massive JOIN query a bit and hopefully avoiding any errors similar to the one mentioned above.
 * Requires: ctg_items
 * Used by:

SQL
CREATE OR REPLACE VIEW qryCtg_Items_active AS SELECT * FROM ctg_items AS tgi WHERE tgi.isActive AND (tgi.PriceSell IS NOT NULL) AND (tgi.ID_ShipCost IS NOT NULL);