Enum JoinType

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Comparable<JoinType>

    public enum JoinType
    extends java.lang.Enum<JoinType>
    An enumeration specifying the different types of join operation.
    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      ANTIJOIN
      Antijoin (aka anti-semijoin), where the left table's rows are included when they match none of the rows from the right table.
      CROSS
      Cross joins, which are simply a Cartesian product.
      FULL_OUTER
      Full outer joins, where non-matching rows from either the left or right table are included in the results.
      INNER
      Inner joins, where only matching rows are included in the result.
      LEFT_OUTER
      Left outer joins, where non-matching rows from the left table are included in the results.
      RIGHT_OUTER
      Right outer joins, where non-matching rows from the right table are included in the results.
      SEMIJOIN
      Semijoin, where the left table's rows are included when they match one or more rows from the right table.
    • Constructor Summary

      Constructors 
      Modifier Constructor Description
      private JoinType()  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static JoinType valueOf​(java.lang.String name)
      Returns the enum constant of this type with the specified name.
      static JoinType[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.
      • Methods inherited from class java.lang.Enum

        clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf
      • Methods inherited from class java.lang.Object

        getClass, notify, notifyAll, wait, wait, wait
    • Enum Constant Detail

      • INNER

        public static final JoinType INNER
        Inner joins, where only matching rows are included in the result.
      • LEFT_OUTER

        public static final JoinType LEFT_OUTER
        Left outer joins, where non-matching rows from the left table are included in the results.
      • RIGHT_OUTER

        public static final JoinType RIGHT_OUTER
        Right outer joins, where non-matching rows from the right table are included in the results.
      • FULL_OUTER

        public static final JoinType FULL_OUTER
        Full outer joins, where non-matching rows from either the left or right table are included in the results.
      • CROSS

        public static final JoinType CROSS
        Cross joins, which are simply a Cartesian product.
      • SEMIJOIN

        public static final JoinType SEMIJOIN
        Semijoin, where the left table's rows are included when they match one or more rows from the right table.
      • ANTIJOIN

        public static final JoinType ANTIJOIN
        Antijoin (aka anti-semijoin), where the left table's rows are included when they match none of the rows from the right table.
    • Constructor Detail

      • JoinType

        private JoinType()
    • Method Detail

      • values

        public static JoinType[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (JoinType c : JoinType.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static JoinType valueOf​(java.lang.String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
        java.lang.NullPointerException - if the argument is null