The SQL statement:
produces the error
Because I can run the query
by itself, I assume that this isn't really a syntax error. What's going on?
Code:
SELECT tTitles.FKey FROM tTitles INNER JOIN tTitles ON (SELECT [ptr->tAAA] FROM tTitles WHERE (((Title) Like "*John*"))) = [ptr->tAAA]
Syntax error. in query expression '(SELECT tTitles.Key FROM tTitles INNER JOIN tTitles ON (SELECT DISTINCT [ptr->tAAA] FROM tTitles WHERE (((Title) Like "*John*"))) = [ptr->tAAA]'.
Code:
SELECT DISTINCT [ptr->tAAA] FROM tTitles WHERE (((Title) Like "*John*"))
Comment