Link to home
Create AccountLog in
Avatar of Cathy_Ryan
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 table1.id=table2.id


the table2.id corresponds to the table1.id primary key
Avatar of Cathy_Ryan
Cathy_Ryan

ASKER

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).  
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

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