Ambiguous field reference 'Item'.
Error 3079
The specified field reference could refer to more than one table listed in the FROM Clause (SQL) In the following example, the Order ID field exists in both the Orders and Order Details tables. Because the statement doesn't specify which table Order ID belongs to, it produces this error.
SELECT [Order ID]
FROM Orders, [Order Details];
To complete this operation, fully qualify the field reference by adding a table name. For example:
SELECT Orders.[Order ID]
FROM Orders, [Order Details];
See Also
SELECT Statement (SQL)