Orders contains three rows for CustomerID 7; Customer contains two duplicate rows for that ID. What happens when an inner join matches only CustomerID?

1. It produces six joined rows for that customer
2. It automatically chooses the newest customer row
3. It produces exactly three rows
4. It rejects all joins on duplicate keys