JOIN operation 'Item' refers to a non-joined table.

Error 3082

You tried to execute an SQL statement29F05E5 that contains an invalid join1LQIV1I.  This error occurs when you try to create a join on a field that isn't in one of the joined tables.  The following example produces this error.

SELECT Authors.[First Name], Titles.[ISBN]
FROM Authors, Titles, AuthorTitles,
Authors INNER JOIN Titles ON Authors.ID = AuthorTitles.ISBN;

The error occurs because the join involves the Authors and Titles tables, but the joined fields are in the Authors and AuthorTitles tables.

See Also

INNER JOIN Operation (SQL)11BWCB0

LEFT JOIN, RIGHT JOIN Operations (SQL)AKPI8QA