I have two tables of the form create table1 (id1 int, t1 text) create table2 (id2 int unique, t2 text)
the data in table 1 is such that some values for t1 are NULL ID1 can contain duplicates ID2 is unique and for every instance of ID1 in table1 there will be a corresponding ID2 entry in table2 t2 in table 2 is always populated with a string For those entries in table1 where there is a null in t2 I want to copy the corresponding entry from table2 any ideas? thx. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users