QUERY: select * from ANNUAIRE where CLIENT=1 and ( (SOUNDEX(ANNU_NOM)=SOUNDEX("chaudi��re bois") OR ANNU_NOM LIKE "%chaudi��re bois%" OR ANNU_MOTCLE LIKE "%chaudi��re bois%") OR (ANNU_ID IN (SELECT DISTINCT (annu_id) FROM societe WHERE descriptif LIKE "%chaudi��re bois%") ) )