Can you show the rest of your Make Query Table screen, e.g., the Key Field Options and Key Fields settings? Also, have you tried "ADD_VIRTUAL_KEY_FIELD" instead of "USE_KEY_FIELDS"?
Also, the documentation states "All input feature classes or tables must be from the same input workspace." Are both your tables in the same input workspace?
As I found in this thread: Make Query Table problem
The issue seems to be with the quotation marks in the SQL statement. I had the same problem as you, and it resolved once I removed the quotation marks...