Show / Hide Table of Contents

    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.
    Back to top Generated by Appeon