> Is there somewhere that it is explained how to do this in SQLITE? There's no way for this in SQLite. You have to rewrite your update statement to be for example like UPDATE ... WHERE id IN (SELECT ... )
> I want to add a column to T1 for the appropriate sex for a given ID from T2. Sorry, I couldn't understand from this what do you really need, so cannot suggest any statement that could do it. You can send us your UPDATE FROM statement that you have used, we will figure out how to change it for SQLite. Pavel On Mon, Oct 5, 2009 at 5:01 PM, ws <[email protected]> wrote: > In Postgresql, there is a (nonstandard) way to specify multiple tables in an > update clause, useful when updating a table with columns based on an inner > join > idea. > > Is there somewhere that it is explained how to do this in SQLITE? > > Example > > Table 1 has ID, age > > Table 2 has ID, sex > > I want to add a column to T1 for the appropriate sex for a given ID from T2. > > Tx! > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
