ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

left outer join

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • left outer join

    hi all,

    what the different LEFT OUTER JOIN and LEFT JOIN ? ?

    thx u

  • #2
    Re: left outer join

    None. It is exactly the same thing.

    From the SQL Manual
    LEFT JOIN or LEFT OUTER JOIN
    The result of T1 LEFT OUTER JOIN T2 consists of their paired rows and, for each unpaired row of T1, the concatenation of that row with the null row of T2. All columns derived from T2 allow null values.
    Philippe

    Comment

    Working...
    X