Update Query

[durdle]

Hey,

I want to run an update query based on two queries. In tblone i have three fields activity, name, and id(PK). In tbltwo i have id, empl#. I want to add a field to tblone called empl# and run an update from tbltwo with the empl#. Only problem is in tblone the id with appear more than once, so when I tried to up the data it failed.

Any ideas?

durdle
________
headshop

 

[Jack Cowley]

Hmmm. How can tbleone have duplicate primary keys? This should not be possible. The first thing you need to do is clean the data or table and then try again....

Jack