var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: problem of getting name of the second director
Hi everybody have two tables first is the member table with fields
The second is the course table
SELECT (familyname + firstname) firstmembername
from member inner join course ON member.memberid=course.memberid
The above query just get the firstmembername of the first relationship with meberid... how could i get the familyname and firstname of memberid2 using the same query
thanks for the help
Because you have a flawed design (heaven help you if more than two memebers can be on a course) you need to join to the member table twice.
First normal form - Wikipedia, the free encyclopedia
ur codings are working excelent.
Thanks yes i need to modify the table design for that... Thanks anyway