> PreparedStatement stmt = conn
> .prepareStatement("SELECT tags.tag "
> + "FROM ( tags, has_tag ) WHERE
> has_tag.content_id=? "
> + "AND has_tag.tag_id=tags.tag_id");
> stmt.setLong(1, id);
You could try doing "FROM (tags tags, has_tag has_tag)"
sqlite may only like "tags.tag" if "tags" is explicitly defined as an
alias and not default to table names.
Haven't tried it, just an idea.
- Stephen
_______________________________________________
SQLiteJDBC mailing list
[email protected]
https://lists.hcoop.net/listinfo/sqlitejdbc
