[SQLiteJDBC] SQLException: no such column

Markus Fuchs mfuchs13 at googlemail.com
Wed Dec 23 15:28:10 EST 2009


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

This doesn't work either, but thanks for your suggestion.
For now I've implemented a workaround with a query for each table, but
this is imho neither elegant nor efficient.

- Markus



More information about the SQLiteJDBC mailing list