SELECT s.skuId, s.sku, s.skudesc, s.ownerid, s.brandid, m.MFR_NAME, s.mfrid FROM tbl_PRD_Skus s INNER JOIN tblManufacturers m ON s.mfrid = m.mfr_id where s.skuid = ", "ALL")>