VbzCart/queries/qryCtg Items active
Jump to navigation
Jump to search
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:
- REDIRECT Template:l/vc/query
SQL
<mysql>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);</mysql>