Link to home
Create AccountLog in
Avatar of Cathy_Ryan

asked on

join in access 2000

table 1 has one record per customer.  Table 2 has many records per customer.  I would like to display the one row on  table 1 if the customer is on table 2
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

select * from table1
inner join table2 on

the corresponds to the primary key
Avatar of Cathy_Ryan


I tried the select and I get 41703 rows displayed.  I only have 5656  customers in table 1 and table 2 has 62203, but, only 625 customers (multiple products per customer).  I expected to see less than 625 rows. I only want to see table 1 records (one pre customer) if the customer exists on table 2 (one customer many products).  
Avatar of als315
Flag of Russian Federation image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account