有关Delphi 7,ADO和&的帮助MS Access SQL语句 [英] Help with Delphi 7, ADO, & MS Access SQL Statement
问题描述
我有三个表(在MS Access Database 2000文件* .mdb中)
I have three tables (in a MS Access Database 2000 file *.mdb)
知识
id
问题
答案
Knowledge
id
question
answer
Knowledge_Keywords
id
知识ID
keywordid
Knowledge_Keywords
id
knowledgeid
keywordsid
关键字
id
关键字
Keywords
id
keyword
需要全部获取知识的关键字
Need to get all the keywords for a knowledge
从关键字KW
中选择不同的关键字在KKW.joinword_id = KW.id
$ b $上加入Knowledge_keywords KKW b在K.id = KKW.knowledgeid
上加入知识K,其中k.id = 10
Select distinct keyword from keywords KW
Join knowledge_keywords KKW on KKW.keywordid = KW.id
Join Knowledge K on K.id = KKW.knowledgeid
Where k.id = 10
当然10是一个示例,我实际上使用
of course 10 is a example, i actually use a parameter there
其中k.id =:AKnowId';
Where k.id = :AKnowId';
并填写代码
qry.Parameters.ParamByName('AKnowId')。Value:= AKnowledgeId;
qry.Parameters.ParamByName('AKnowId').Value:= AKnowledgeId;
无论如何,我认为SQL可能会出错,将不胜感激
anyway, i think the SQL is qrong, any help would be greatly appreciated
推荐答案
解决了!
从不同的关键字中选择
(关键字KW
内部,在KKW.joinword_keywordid = KW.id上加入Knowledge_keywords)< br>
内部加入知识K上的K.id = KKW.knowledgeid
其中k.id = 10
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
这篇关于有关Delphi 7,ADO和&的帮助MS Access SQL语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!