Error(Multiple Relations) While Coding SQL in Access 2010
Posted 16 August 2013 - 08:44 AM
I'm writing a sql query in Access 2010 and getting an error message saying that the field I am selecting is used in multiple relations so I need to select from just one table. I thought that I had the correct code for explicitly telling it which table to select from but I am still getting that error.
This is what I am coding.
INNER JOIN Batch