Table Updates (TableInventory) and (TableUpdates)

M

ms newsgrp

I am having problem with updating information to a table from another table.

I have table storing the information on a the inventory (TableInventory).
Its needs to be updated with information from another table containing
specific updates for the inventory (TableUpdates). The items in the
TableInventory are identified by their unique IDs. This unique ID is match
with update information in items in the table TableUpdates.

How do I use SQL and TSQL to update TableInventory with the information in
TableUpdate? TableUpdate also contains new items not found in
TableInventory with needs to be added as well.

Thanks you in advance.
 

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

Similar Threads

Search and Replace with Table rows 1
Crating User Form to Add Names 1
Update Query is not Working / Updateting 1
How to have two tables on same line? 1
List all tables, including document structure 0
Creating a Chart on form from selected data in query. 0
Auto-Numbering in a Table in MS Word 1
Linking data in MS Word into Excel 5

Top