Hi, I need to implement a recursive update for some reason.
So I'm trying to start to implement a stupid with-clause update and that stops me immediately. The update does not recognize the table or columns of the with clause table: with mt(a, b) as ( select i, j from ... ) update tab set x = mt.a where y = mt.b error message : there is no column mt.a. What is wrong ? I tried to find some mailing on that but its very hard because the search engine delivers nearly everything for the search phrases " with clause update". Anybody out there who can help ? Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users