Geek asks and answers

LEFT OUTER JOIN expressed as LEFT JOIN in MySql syntax?

Is it LEFT OUTER JOINexpressed only like LEFT JOINin MySQL syntax? Or LEFT OUTER JOINand LEFT JOINdifferent things in MySQL?

+5
source share
1 answer

They are basically the same.

LEFTand RIGHTare outertype join. The keyword outeris optional, and in this case it means that regardless of whether you specify it or not, it does not matter.

Additional Information,

At the top level, there are basically 3 types of associations:

  • INTERNAL
  • EXTERNAL (LEFT, RIGHT)
  • Cross
+7
source

More articles:


All Articles