help with sql query - in access 2007

Question

hi

i have 2 tables

table items has 144602 records

table A has 27721 records

code in items = BAR8 in A

i want to show all records that equal

i try this: SELECT Items.Code, A.BAR8 FROM Items INNER JOIN A ON Items.Code = A.BAR8;

and i get 28048 records !!! i need to get 27721 , how to do it ?

thank's in advance

Answer 1

try

SELECT distinct * 
FROM Items INNER JOIN A ON Items.Code = A.BAR8;