Roy,

<wild cackling laughter> until they find out all the useful data was on the subsequent records - then they blame you </wild cackling laughter>

This may help a bit. It will return the latest record with a MatchingField. This assumes the latest record has the more recent data.

update _Tmp2 T
Set T.ParentID = (Select ID From Names where MatchingField = T.Matchingfield order by SomeDate desc range 1 to 1)

It would be nice if everyone had properly normalized databases to eliminate redundancy. But that isn't likely going to happen in my lifetime. Maybe the gov't should start taxing people for having un-normalized data??? "Your data isn't normal - so we're gonna tax it!" ROFL

Barry

Barry


>It would be nice if everyone had properly normalized databases to eliminate redundancy. But that isn't likely going to happen in my lifetime. Maybe the gov't should start taxing people for having un-normalized data??? "Your data isn't normal - so we're gonna tax it!" ROFL

DO NOT LAUGH with the level of IT literacy exhibited by most politicians your scenario is all to likely!

Roy