Table of Contents

Enum JoinType

Namespace
YndigoBlue.Velocity.Enums
Assembly
YndigoBlue.Velocity.dll

Specifies the type of SQL JOIN operation to perform between tables.

public enum JoinType

Fields

Inner = 1

Inner join returns only rows that have matching values in both tables.

LeftOuter = 2

Left outer join returns all rows from the left table and matching rows from the right table.

RightOuter = 3

Right outer join returns all rows from the right table and matching rows from the left table.

FullOuter = 4

Full outer join returns all rows from both tables, with NULL values where no match exists.

Remarks

Join types determine which rows are included in the result set when combining data from multiple tables based on a related column.