update a field in one table from another field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Earl Takasaki - 31 Aug 2006 20:57 GMT

Is there a simple way to update a field in one table from a field in another
table? The SQL that works in SQL Server doesn't seem to work in access...

update tbl1 T
set T.field = S.field
from T inner join S on T.field = s.field

Signature

Earl Takasaki
Master of Financial Engineering Candidate
University of California at Berkeley

Reply to this Message

Klatuu - 31 Aug 2006 21:13 GMT

update T inner join S on T.field = s.field set T.field = S.field;

> Is there a simple way to update a field in one table from a field in another
> table? The SQL that works in SQL Server doesn't seem to work in access...
>
> update tbl1 T
> set T.field = S.field
> from T inner join S on T.field = s.field

Reply to this Message