Thep Excel
JoinKind.Type – ระบุประเภทของการ Join
ระบุประเภทของการ Join
ระบุประเภทของการ Join
Resources & Related
Resources
-
Microsoft Learn: JoinKind.Type
Official Documentation
Additional Notes
ระบุประเภทของการ Join
ค่าที่สามารถใช้ได้ (Available Values)
| ชื่อ (Name) | ค่า (Value) | คำอธิบาย |
|---|---|---|
| JoinKind.Inner | 0 | The table resulting from an inner join contains a row for each pair of rows from the specified tables that were determined to match based on the specified key columns. |
| JoinKind.LeftOuter | 1 | A left outer join ensures that all rows of the first table appear in the result. |
| JoinKind.RightOuter | 2 | A right outer join ensures that all rows of the second table appear in the result. |
| JoinKind.FullOuter | 3 | A full outer join ensures that all rows of both tables appear in the result. Rows that did not have a match in the other table are joined with a default row containing null values for all of its columns. |
| JoinKind.LeftAnti | 4 | A left anti join returns all rows from the first table that do not have a match in the second table. |
| JoinKind.RightAnti | 5 | A right anti join returns all rows from the second table that do not have a match in the first table. |
| JoinKind.LeftSemi | 6 | A left semi join returns all rows from the first table that have a match in the second table. |
| JoinKind.RightSemi | 7 | A right semi join returns all rows from the second table that have a match in the first table. |