SqlJoinType Enum

.NET Standard 2.x

The types of SQL JOIN operation.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

  public enum SqlJoinType;

Fields

Name	Description
Join	JOIN (Default). Returns records that have matching values in both tables.
Inner	INNER JOIN, the same as JOIN. Returns only records that have matching values in both tables.
Left	LEFT OUTER. Returns all records from the left table, and the matched records from the right table.
Right	RIGHT OUTER. Returns all records from the right table ,and the matched records from the left table.
Full	FULL OUTER. Returns all records when there is a match in either left or right table.