help...i've never had this happen

[WrathOfThunder]

I am using access and I have 2 tables
One table has 28 records and the other has 122 records.
When I do a normal inner join on my 2 fields my query gives me 224 records. What the hell is going on? I do this all the time and never have I had this happen before. Shouldn't it just give me what records are equal?
Please help?
Thanks

[omalleytrading]

Show us the query.

[WrathOfThunder]

none of these fields are primary or keyed. There may be duplicate info in both tables.
i don't know why I get 224 records returned.

SELECT PLUG_PORT.KEY, PLUG_PORT.FLOOR, PLUG_PORT.BAY_NODE, PLUG_PORT.SHELF, EQUIPMENT_PORT.PARTITION_FROM, EQUIPMENT_PORT.STATUS_TYPE
FROM PLUG_PORT INNER JOIN EQUIPMENT_PORT ON PLUG_PORT.KEY = EQUIPMENT_PORT.KEY;

[omalleytrading]

Try this:

SELECT p.KEY, p.FLOOR, p.BAY_NODE, p.SHELF, e.PARTITION_FORM, e.STATUS_TYPE
FROM PLUG_PORT p LEFT JOIN EQUIPMENT_PORT e
ON p.KEY = e.KEY;