If i have two tables that need to be joined matching two values from each table, lets say Columns  1 and 2 on both table.
If i set in one table two lookups to the same table will it work?

Or would I need to create a query table like so:

SELECT Table1.[Columns] , Table2.[Columns]

FROM Table1
LEFT JOIN Table2 on
      Table1.Column1 = Table2.Column1
      AND Table1.Column2 = Table2.Column2