|
The Full Join keyword will return records if there is a match in one of the tables.
Table Name ‘Users’
|
U_Id
|
FirstName
|
LastName
|
City
|
|
1
|
Ajay
|
senha
|
New York
|
|
2
|
Vinda
|
kapoor
|
Los Angeles
|
|
3
|
Qasim
|
bilal
|
New York
|
In this table U_Id is primary key.
Table Name ‘UserCourses’
|
Uc_id
|
CourseNo
|
U_Id
|
|
1
|
34190
|
1
|
|
2
|
34192
|
1
|
|
3
|
34190
|
2
|
|
4
|
34187
|
4
|
|
|
|
|
SELECT Users.U_Id, Users.FirstName, Users.LastName, UserCourses.CourseNo
FROM Users
FULL JOIN UserCourses
ON Users.U_Id=UserCourses.U_Id
Order By Users.U_Id
Result:
|
U_Id
|
FirstName
|
LastName
|
CourseNo
|
|
1
|
Ajay
|
senha
|
34190
|
|
1
|
Ajay
|
senha
|
34192
|
|
2
|
Vinda
|
kapoor
|
34190
|
|
3
|
Qasim
|
bilal
|
|
|
|
|
|
34187
|
|
