-
Notifications
You must be signed in to change notification settings - Fork 0
JoinType
Jacob Spitzer edited this page Aug 28, 2022
·
2 revisions
SQL Join Type enumeration
public enum JoinType
FullJoin
3
FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table
InnerJoin
0
(INNER) JOIN: Returns records that have matching values in both tables
LeftJoin
1
LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
RightJoin
2
RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table