Hi sqlite user, I try to update a table field with a selected value from same tabel. Is this possible? What I try yet is: update TableA Set FieldA = (select FieldB from TableA where IDField = updateData.IDField AND TimeStamp = date(updateData.TimeStamp, '-1 day'));
I want to update the FieldA with FieldB one day earlyer, where IDField is the same. I know that " updateData." will not work, its only a placeholder, because I dont know how to tell sqlite to compare with update row. Can you help me? :( Regards Steffen _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
