Can't join on Memo or Long Binary (Item).
Error 3118
You can't join1LQIV1I Memo or Long Binary fields.
See Also
LEFT JOIN, RIGHT JOIN Operations (SQL)AKPI8QA