Join Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to insert customer names from a customer names table into a table
that only has customer numbers by using a query. I have linked the customer
numbers in both tables. In the table with only customer numbers I have 900
records. When I execute the query the customer names are inserted but I end
up with 930 records. Why is this happening? I only want the names inserted
into the 900 original records.
 
The most likely cause is that you have duplicate customer numbers in your
customer names table.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to insert customer names from a customer names table into a
table
that only has customer numbers by using a query. I have linked the customer
numbers in both tables. In the table with only customer numbers I have 900
records. When I execute the query the customer names are inserted but I end
up with 930 records. Why is this happening? I only want the names inserted
into the 900 original records.
 
Back
Top