What is the difference between LEFT JOIN and LEFT OUTER JOIN?

Asked

Viewed 3,608 times

1

What’s the difference between LEFT JOIN and LEFT OUTER JOIN? Can you give me some examples?

mysql sql
  • 1

    Maybe this answer will help. https://answall.com/questions/6441/qual-%C3%A9-a-difference%C3%a7a-entre-Inner-Join-e-outer-Join/6448#6448

  • Duplicate: https://answall.com/questions/6441/qual-é-a-diferença-entre-inner-join-e-outer-join

1 answer

6


None.

If you check the mysql documentation will see that it is placed

joined_table:
    table_reference {[INNER | CROSS] JOIN | STRAIGHT_JOIN} table_factor [join_specification]
  | table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference join_specification
  | table_reference NATURAL [INNER | {LEFT|RIGHT} [OUTER]] JOIN table_factor

Where we can highlight the part {LEFT|RIGHT} [OUTER]. The square brackets around OUTER indicate that it is optional in SQL and therefore will be considered by default.

That is to say, LEFT JOIN and LEFT OUTER JOIN are exactly the same.

  • Thank you very much!! !

Browser other questions tagged mysql sql

You are not signed in. Login or sign up in order to post.