select cho_name from tbl_CHO_Operators with (nolock) where cho_id = select s.skuId, s.sku, s.skuDesc, m.MFR_NAME, b.brand, pkg.SCC14 as gtin from tbl_PRD_SKUs s with (nolock) left outer join tbl_PRD_Packaging pkg with (nolock) on s.skuId = pkg.linkId inner join tblManufacturers m with (nolock) on m.MFR_ID = s.mfrId left outer join tbl_MFR_Brands b with (nolock) on b.mfr_id = m.mfr_id and b.brand_Id = s.brandId and m.MFR_ID = where s.skuId = select firstName, lastName, email from tbl_FSPRO_Members with (nolock) where fspro_userId = select email from tbl_FSPRO_Members with (nolock) where fspro_userId =