... WHERE BusinessTime.NoProvince= CASE WHEN (SELECT Company.NoCountry FROM Company WHERE Company.Numero=Client.NoCompany)=1 THEN (SELECT Company.NoProvince FROM Company WHERE Company.Numero=Client.Company) ELSE 84 END AND BusinessTime.NoHoliday=0 AND BusinessTime.Start<Client.FirstDate AND BusinessTime.[End]>=Client.SecondDate) Temp) ...Is there a way to avoid doing two select in the company table to satisfy that need?