Large table merge

All,
I have two large table A:120K record, B: 40K record, try to get the B's 2 field info into A.
A and B has 4 common field, those 4 field in B no null values, in A 2 of the fileds has null values.

I use join A and B, but it takes me many hours, how should I do to gain the speed, I saw sombody do the same thing only take 7 minutes.

Thanks,
Christina Received on Sun Nov 25 2001 - 00:57:32 CST