thugster69
Active member
- Joined
- Jun 17, 2010
- Messages
- 35
- Programming Experience
- Beginner
Hey Guys,
Good day! I just want to learn how to join 3 tables in my SQL Database?
Here is the structure:
Table Name: Section1
Fields: Student Number
Table Name: New Student
Fields: Student Number
Last Name
First Name
Middle Name
Table Name: Old Student
Fields: Student Number
Last Name
First Name
Middle Name
How can I join records from [Old Student] and [New Student] tables by using the [Student Number] field in the Section1 table?
This is a representation of the desired result
I've tried right, inner, outer join and even Union.. But still, to no avail.. Can you help me on this one mates?
Thank you very much!
Good day! I just want to learn how to join 3 tables in my SQL Database?
Here is the structure:
Table Name: Section1
Fields: Student Number
Table Name: New Student
Fields: Student Number
Last Name
First Name
Middle Name
Table Name: Old Student
Fields: Student Number
Last Name
First Name
Middle Name
How can I join records from [Old Student] and [New Student] tables by using the [Student Number] field in the Section1 table?
This is a representation of the desired result
VB.NET:
[COLOR="blue"]Student Number | Last Name | First Name | Middle Name[/COLOR]
1000 Doe John Kennedy <=came from new student
2000 Doe Jane Maslow <=came from old student
Thank you very much!
Last edited: