Dermot <paik...@googlemail.com> wrote: > I want to do a select query a bit like this: > > SELECT * FROM tbl1 WHERE description="someval" AND > foreign_key_id=(select id from tbl2 where name="Joe"); > > This gives me a syntax error and my other efforts are not yielding > results.
What's the text of the error message? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users