Garaud Jean-Claude a écrit :
Autres solutions :
mysql> select distinct(t2.Films) from table1 t1, table2 t2 where t2.Films like
concat('%', t1.Mots, '%');
ou encore :
mysql> select distinct(t2.Films) from table1 t1 inner join table2 t2 on
t2.Films like concat('%', t1.Mots, '%');
donnent :
+-----------------------+
| Films |
+-----------------------+
| Le cuirassé Potemkine |
| La règle du jeu |
+-----------------------+
Un simple :
select * from table2,table1 where table2.films like concat
('%',table1.mots,'%');
semble fonctionner !
____________________________________________________
Want to buy your Pack or Services from Mandriva?
Go to http://store.mandriva.com
Join the Club : http://www.mandrivaclub.com
____________________________________________________
