help with sql query - in access 2007

Posted by Gold on Stack Overflow See other posts from Stack Overflow or by Gold
Published on 2010-05-15T05:28:03Z Indexed on 2010/05/15 5:34 UTC
Read the original article Hit count: 149

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about access

Related posts about query