title: Help with Delphi 7, ADO, & MS Access SQL Statement
body: <p>I have three tables (in a MS Access Database 2000 file *.mdb)  </p>
  
  <p>Knowledge<br>
  id<br>
  question<br>
  answer  </p>
  
  <p>Knowledge_Keywords<br>
  id<br>
  knowledgeid<br>
  keywordsid  </p>
  
  <p>Keywords<br>
  id<br>
  keyword  </p>
  
  <p>Need to get all the keywords for a knowledge  </p>
  
  <p>Select distinct keyword from keywords KW<br>
  Join knowledge_keywords KKW on KKW.keywordid = KW.id<br>
  Join Knowledge K on K.id = KKW.knowledgeid<br>
  Where k.id =  10  </p>
  
  <p>of course 10 is a example, i actually use a parameter there  </p>
  
  <p>Where k.id = :AKnowId';  </p>
  
  <p>and fill it in in code  </p>
  
  <p>qry.Parameters.ParamByName('AKnowId').Value:= AKnowledgeId;  </p>
  
  <p>anyway, i think the SQL is qrong, any help would be greatly appreciated</p>