Once again, I've gotten stumped on a complex query. Basically, we have a DB with 3 tables. Here is the query structure:
The code do not works fine giving the following message:
rs.open "Select TESTB.Contents From TESTA inner Join TESTC On (TESTC.OrderID = TESTA.IndexID) inner Join testb On (testb.indexid = TESTC.Ex_usoID) Where testa.word like '%"&StrKeyword&"%' ", conn
Syntax error (missing operator) in query expression '(TESTEC.OrderID = TESTEA.IndexID) inner Join testeb On (testeb.indexid = TESTEC.Ex_usoID)'.
Thanks for any help you can provide