Update field from other table

A

Anna

Hi,

I have two tables: both have the fields Code and Desc (but
the Desc values are different in each table).
How can I update table A's Desc field to table B's when
the codes are the same?
(i.e. if code a = code b , insert DescB value for code b
record in DescA field of code A record)

Hope this made sense!
Help gratefully received....

Thanks
Anna
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top