Hi There
Could anyone please help me with the following problem.
I have a geological drill hole database with a table containing down hole rocktype.
with fields Hole ID, From, to and rocktype.
I have a second table that I have generated from a gold assay table of intercepts
which only contains the high grade intercepts. I have added a rocktype field to this
intercepts table and I want to update this field with the appropriate rocktype code
from the rocktype table. The problem is that the from and to fields in the assay
table can be different to the from and to's of the rocktype table but are often the
same. What I would like to do is update those records which exactly match in the Hole
ID, From and to fields and then I'll have to go through and manually complete the
rest. But how do I do the update column join on the three field matches I want (there
is no unique identifier for the records). I want to retain my assay intercept table
as it is - I can't see how I can use SQL select and achieve this.
Hope thats not too confusing.
Any ideas
Cheers
Steve King
