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