Re: select subquery

Harald Hanche-Olsen <[email protected]> Thu, 16 Dec 2010 14:22:29 +0100 (CET)

Newsgroups	gmane.lisp.clsql.general
Message-ID	<[email protected]>

[Fulvio Ciriaco <[email protected]> (2010-12-16 10:15:51 UTC)]

> 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)

I think

  (clsql:select [a] :from [tablea] :where
    [in [id] [select [c] :from [tableb]]])

should work.

- Harald