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 ia.invite = i.id; > > It complains about "no such column: j.id". Are the 'as' clauses not > accessible from outside the () in sqlite?
No. But why do you need those parentheses? Why not just SELECT i.user, ia.key, ia.value FROM invite AS i JOIN invite AS j ON i.parent = j.id JOIN users AS u ON (j.user = u.id AND u.canonical_username='ludde') LEFT JOIN inviteattr as ia ON ia.invite = i.id; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users