T-SQL :

Select * from Gecoserv where typeOfEcosystem IN (:typeNameList) AND service IN (:serviceNameList)