select * from tbl_CHO_Operators with (nolock) where cho_type = 'G' and cho_1FSSchoolsMember = 'Y' order by cho_name select cho.cho_id as orgId, cho.cho_name as companyName from tbl_CHO_Operators cho with (nolock) inner join tbl_OPR_ClientOperators opr with (nolock) on opr.fsl_choId = cho.cho_id where opr.ownerId = and opr.fsltablecode = 'CHO' and opr.crmActive = 'Y' order by cho.cho_name select distinct mfr.mfr_id as mfrId, mfr.mfr_name as mfrName from tbl_OFS_FlatSearch ofs with (nolock) inner join tblManufacturers mfr on mfr.mfr_id = ofs.mfr_id where ofs.skuOwnerType = 'CHO' and ofs.skuOwnerId = order by mfr.mfr_name
Tab 2 content
Tab 3 content