In Access you need parentheses if you have more than one join. Create Link tables in Access 2007 External Data -->More -->ODBC Database