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
