In Access, if I want to update one table with information from another,
all I need to do is to create an Update query with the two tables, link
the primary keys and reference the source table(s)/column(s) with the
destination table(s)/column(s). How do I achieve the same thing in SQL?


Regards
Colin

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