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 column: j.id". Are the 'as' clauses not accessible from outside the () in sqlite? Is this a bug in sqlite or in my query?, it works fine in postgres. /Ludde _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
