il faut que la sous-requete comporte un seul champ.


select * from latable_1
where <conditions>
...
champ_x in (select champ_x from latable_2)