TO KRETZSCHMAR OR GEOBUL (master-detail with sql or ...!?)
Posted on 2003-03-22
I have four tables:
1-article(Aid,description,title,abstract); AID=P.K relation:
2-keywords( AID,keyword) ; aid+keyword=p.k , aid=f.k article 1->n student , Keywords màn article
3-student(sid ,AID,sname,grade); sid=p.k, aid=f.k article màn teacher
4-teacher(tid,aid,tname,support); tid+aid=p.k , aid=f.k
I want to show the article list( with special keyword) in web pages (as google page search)
After search for a special keyword(keywords). In my description about one article on html page these fields should be exist:
3-student names( pay attentionà student names)
4-teache names (pay attentionà teacher names)
Yes, this is a implementing of master-detail relationship between article and student and teacher.
I don’t any question in how can communicate between Delphi and html creating.
but I cant write any sql statement that bring all of student names that create a article without any repeating of article name so teacher names .
can you write a special sql statement or any other works that include the student names for a special article(not repeated the article name)?
I m really expect to hear from you.
thanks in advance