PROBLEM WITH: DROP TABLE IF EXISTS z_hd_bcg_shopped

PROBLEM WITH: DROP VIEW IF EXISTS z_hd_bcg_shopped

PROBLEM WITH: CREATE TABLE z_hd_bcg_shopped (ProductID int, ordinal tinyint, outshop int, qty float , PRIMARY KEY(ProductID, ordinal, outshop))

PROBLEM WITH: select ProductID, dbProductName from tq_admin.vw_companies_products where CompanyID=326 order by ProductID