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
