I currently have a table(t1) with two fields(f1, f2) that are populated with data
I have another table(t2) with two fields(f1, f2) where f1 is the only field populated with data
t1.f1 and t2.f1 have a one to one relationship.
I want to transfer the data from t1.f2 to t2.f2 where t1.f1 and t2.f1 are equal.
I tried using UPDATE but I have so much data, it takes to long.
Any suggestions would be appreciated
dr
I have another table(t2) with two fields(f1, f2) where f1 is the only field populated with data
t1.f1 and t2.f1 have a one to one relationship.
I want to transfer the data from t1.f2 to t2.f2 where t1.f1 and t2.f1 are equal.
I tried using UPDATE but I have so much data, it takes to long.
Any suggestions would be appreciated
dr