Generic filters
Exact matches only
  • Difference between inner and outer join

    26th February 2014

    MySql

    mysql codehaven category

    If you just mention JOIN then by default it is a INNER JOIN.
    An OUTER join has to be LEFT | RIGHT | FULL you can not simply say OUTER JOIN.
    You can drop OUTER keyword and just say LEFT JOIN or RIGHT JOIN or FULL JOIN.

    Totally the best answer including code examples…. Difference between inner and outer join – Stack Overflow.

    Was this code snippet helpful?