JOIN operation 'Item' refers to a non-joined table.
You tried to execute an SQL statement 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. that contains an invalid join .
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.
INNER JOIN Operation (SQL)
LEFT JOIN, RIGHT JOIN Operations (SQL)