select subquery

Hallo,
it is now some time I use clsql with postgresql, however
I could not discover how to put together an sql expression
like:
select a from tablea where id in (select c from tableb)
Fulvio