Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Query 1

Status
Not open for further replies.

Dashley

Programmer
Dec 5, 2002
925
US
I'm not used to using access sql.
Here's what I'm tring to do.


table1 table2
ISBN | Author | Description ISBN | Description

all fields are text

I want to update table1.description with table2 description where table2.ISBN = table1 ISBN

thanks.
 
Code:
UPDATE Table1 INNER JOIN Table2
       ON Table1.ISBN = Table2.ISBN

SET    Table1.Description = Table2.Description
 
Golom

Wow you made that too easy. I was trying an inner selet.


Thanks


dash
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top