Dear The Expert,
I have 2 tables:
- Student
StudentID VARCHAR(5)
StudentName VARCHAR(50)
EmailAdd VARCHAR(50)
- Topics1
TopicDate DATE
TopicSubject VARCHAR(50)
TopicFrom VARCHAR(5)
TopicTo VARCHAR(5)
Joining criteria: TopicFrom = StudentID and TopicTo = StudentID
How to join the above tables into 1 table?
What I need is: to get the following fields:
TopicDate, TopicSubject, TopicFrom, FromStudentName, FromStudentEmail, TopicTo, ToStudentName, ToStudentEmail
please advise and many thanks in advance
Regards
Winanjaya
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement