Steffen Mangold <[email protected]> wrote:
> 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.
update TableA set FieldA = (
select FieldB from TableA t
where t.IDField = TableA.IDField and
t.TimeStamp = date(TableA.TimeStamp, '-1 day')
);
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
