Hi All,
I'm trying to make the following SQL statement lispy by converting it to
s-sql:
SELECT * FROM filter
WHERE title
IN ( SELECT filter_title FROM user_filter WHERE user_id = 4);
Here's my best attempt:
:SELECT '* :FROM 'filter
:WHERE 'title
:IN (:SELECT 'filter_title :FROM user_filter :WHERE (:= 'user-id 3))
However, I get the following error:
Keyword WHERE takes exactly one argument
I've tried the SQL query in psql so I know it works, but I can't seem to
come up with an equivalent s-sql statement.
Thanks for any assistance,
Sam
--
Sam Alves
Package Maintainer
OSHEAN, Inc.
Email: s...@oshean.org
_______________________________________________
postmodern-devel mailing list
postmodern-devel@common-lisp.net
http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
