Is it possible to permit this behaviour? CREATE TEMP TABLE user_record (id INTEGER PRIMARY KEY, user_id INTEGER, name TEXT); CREATE TEMP VIEW v_user AS SELECT id, name, (SELECT name FROM v_user WHERE id=r.user_id) as "user" FROM user_record as r; Error: no such table: v_user
-- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
