sqlite - set a row to perform a function on another row -

is @ possible following:

create table t1(        t1_id integer primary key,        integer);  create table t2(        t2_id integer primary key,        b integer);  create table t3(        t1_id integer primary key,        c integer t(a) + t(b)); 

where row in table performs simple function on 1 or more other rows (either in same table or shown above), automatically update when changes occur? couple of hours of googling , still find myself none wiser.

i think looking this:

create view ab select t1.a + t2.b t1, t2 t1.t1_id = t2.t2_id