I have a table T1 which has the following columns A, B, C and D.
I have another table T2 having these columns: P, Q, R and S.
Now I want to update the table T1, like this:
I will select the columns from the table T2, and update the columns of T1.
I mean, Column A of T1 should be updated by (Select P from T2),
Column B of T1 should be updated by (Select Q from T2)..
And so on..
Can anyone please help me, in finding the solution for the same?
Thanks in advance.