Hi all
I am having a table table1 having fields t1,t2,t3,t4,t5,t6.
now I am having another table table2 having fields t,value.
table1 is blank and table2 is having some records. I want to append table1 from table2.
I want that if the value of table2.t is 1 its value should replace in table1.t1, same as if table2.t is 5 then its value should replace in table1.t5 and so on....
I want the smallest code to solve this problem. I don't want to use if clause.
Thanks and Regards
I am having a table table1 having fields t1,t2,t3,t4,t5,t6.
now I am having another table table2 having fields t,value.
table1 is blank and table2 is having some records. I want to append table1 from table2.
I want that if the value of table2.t is 1 its value should replace in table1.t1, same as if table2.t is 5 then its value should replace in table1.t5 and so on....
I want the smallest code to solve this problem. I don't want to use if clause.
Thanks and Regards