Posted by Nothing on 10/02/33 11:43

I have a field, Y, in table A that I need to update from table B,
matching on comman field X in both tables.

Table A has 10K+ records with field X in it (Field X multipul times).
Table B has only disctinct records in it based field X. Table B also has
a colume Y that I need to copy to table A's column Y.

So basically I want all of column Y's data in Table B copied to table
A's column Y.

One last point, I am using MS-Access to do the this.

I know this is a simple update command, but I can't seem to get it.

Can any one help me with this?

Thanks.
Mike
m charney at dunlap hospital dot net

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: Row Numbers for a View
• Prev in forum: Re: SQL Server 2005: Migrate DTS to Where?
• Thread view: Update Table

[Reply to this message]