SQL Inner Join Returns WAY More Rows Than Expected

The following query returns >7000 rows when each table on开发者_StackOverflow中文版ly has 340 rows.

SELECT Config.Spec, TempTable.Spec FROM Confg INNER JOIN TempTable on Config.Spec = TempTable.Spec

Why would this happen? If an INNER JOIN only returns a row if there is a match in both tables then why would it return multiple rows for a match.

---

If there is more than one row with the same Spec value in TempTable for the same Spec value in Confg, then you will get duplicate rows, and vice versa.

---

Are the Spec field values non unique? This might explain why the query returns too many results; with duplicates you get get an effective cross product for those.