Ambiguous field reference 'Item'.

Error 3079

The specified field reference could refer to more than one table listed in the FROM Clause (SQL)DQDO8P of your SQL statement29F05E5.  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