In table 1 I have "Name 1" and "08/17/2014" on row 3. This pairing doesn't occur anywhere else in the table, just once on row 3.
I have the same pairing in Table 2, but this pairing appears twice (rows 4 and 5).
I have a query on both tables with a double join between both name fields and date fields. Because the default join is an inner join, I should only see matches both ways. Because of this, I expected to see "Name 1 and 08/17/2014" on one row in the query results, because the 2nd occurrence in table 2 isn't paired to anything in table one. Only the first occurrence in each table is a match.
But instead, the query results have "Name 1 and 08/17/2014" occurring twice (rows 1 and 2). Why am I getting two rows with these values in the query result, instead of only one?