Re: [sqlite] JOIN problem (works in postgres)

Ludvig Strigeus <[EMAIL PROTECTED]> wrote: > The following query does not work in Sqlite: > > SELECT i.user, ia.key, ia.value > FROM invite AS i > JOIN (invite AS j JOIN users AS u ON j.user = u.id AND > u.canonical_username='ludde') ON i.parent = j.id > LEFT JOIN inviteattr as ia ON

[sqlite] JOIN problem (works in postgres)

Hello, The following query does not work in Sqlite: SELECT i.user, ia.key, ia.value FROM invite AS i JOIN (invite AS j JOIN users AS u ON j.user = u.id AND u.canonical_username='ludde') ON i.parent = j.id LEFT JOIN inviteattr as ia ON ia.invite = i.id; It complains about "no such