INFO EQUIPE :

select evm_EQUIPE.equipe from evm_TOURNOI,evm_JOUR,evm_EQUIPE where (evm_TOURNOI.categ='REM') and (evm_TOURNOI.jour='2019-11-16') and (evm_TOURNOI.categ=evm_EQUIPE.categ) and (evm_TOURNOI.jour=evm_EQUIPE.jour) and (evm_TOURNOI.jour=evm_JOUR.jour) and (evm_JOUR.station='STCAST') order by evm_EQUIPE.equipe