Help With Delphi 7, Ado, & Ms Access Sql Statement

I have three tables (in a MS Access Database 2000 file *.mdb) Knowledge id question answer Knowledge_Keywords id knowledgeid keywordsid Keywords id keyword Need to get all

Solution 1:

Get the SQL working properly within Access itself (make a query, try your SQL, see if it returns anything). THEN worry about Delphi.

Solution 2:

Solved it!

Select distinct keyword from (keywords KW inner Join knowledge_keywords KKW on KKW.keywordid = KW.id) inner Join Knowledge K on K.id = KKW.knowledgeid Where k.id = 10