Hello friends
I have two tables t1,t2
data in t1 is
insert into t1(id,name,address) values (1,Sunil,gurgaon)
insert into t1(id,name,address) values (2,Ashok,Delhi)
1 Sunil Narnaul
2 Ashok Narrajnaul
data in table t2
insert into t2(id,name) values (1,Sunil)
insert into t2(id,name) values (2,Ashok)
1 Sunil NULL
2 Ashok NULL
Now I want to insert addess of table t1 into address of table t2 at present values in address of t2 is null.
Pls send me query for this.
Pls Help me out