Update Query 1

[Dashley]

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.

 

[Golom]

UPDATE Table1 INNER JOIN Table2
       ON Table1.ISBN = Table2.ISBN

SET    Table1.Description = Table2.Description

 

[Dashley]

Golom

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


Thanks


dash