By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 767 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

Query to insert field from one table into another table - no unique identifier

P: 1
Hi there,

This is what I am trying to do:

Create a query that will insert a column from Table 2 into Table 1. These two tables are exactly the same in structure, however, there is no unique identifier in either table. For example, Table 1 has fields called Broker Number, Category, and Total Amount, and Table 2 also has fields called Broker Number, Category, and Total Amount. Broker Number and Category are identical in both tables, however, Table 1 has a higher Total Amount than Table 2. I need to be able to insert the Total Amount field from Table 2 into Table 1. Table 1 has 9000 records in total, while Table 2 has 7000.

If anyone can help me out - much appreciated!

Thanks,
Leigh
Mar 9 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,441
So, you want to update (rather than insert) the [Total Amount] field in [Table 1] when, and only when, there is a record in [Table 2] whose [Broker Number] & [Category] fields match those in the record from [Table 1], with the value of [Table 2]'s [total Amount] field?
Mar 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.