SELECT DISTINCT 
tblProductPairings.l_CompanyID,
 tblCompany.b_designer, 
tblCompanyContact.s_CompanyName, 
tblProductPairings.l_ProductPairingID,
 tblProductPairings.l_GarmentID, 
tblProductPairings.l_ProductSectorID FROM 
tblProductPairings JOIN tblCompanyContact ON
 tblCompanyContact.l_CompanyID = 
tblProductPairings.l_CompanyID JOIN 
tblCompany ON tblCompany.l_CompanyID = 
tblProductPairings.l_CompanyID WHERE 
tblProductPairings.l_CompanyID = 35 OR 
tblProductPairings.l_CompanyID = 36 OR 
tblProductPairings.l_CompanyID = 37 OR 
tblProductPairings.l_CompanyID = 38 OR 
tblProductPairings.l_CompanyID = 39 OR 
tblProductPairings.l_CompanyID = 40 OR
tblProductPairings.l_CompanyID = 41 OR

tblProductPairings.l_CompanyID = 42 OR

tblProductPairings.l_CompanyID = 43 OR 

tblProductPairings.l_CompanyID = 44 AND 
l_GarmentID & 2 > 0