SELECT Combine Query

SELECT IC.InsCarrierId,IC.InsCarrierName,
ID.InterchangeControlId,ID.InterchangeName
FROM InsCarrier IC
LEFT OUTER JOIN InterchangeControl ID ON ID.InterchangeControlId=IC.InterchangeControlId
WHERE IC.InsCarrierName LIKE '%'+ @InsCarrierName + '%' --AND ID.InterchangeControlId=@InterchangeControlId