# JOIN issue

**URL:** <https://forums.percona.com/t/join-issue/140>\
**Category:** Other MySQL® Questions\
**Created:** [December 6, 2006, 2:48am UTC](https://forums.percona.com/t/join-issue/140 "2006-12-06T02:48:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![migandhi](https://avatars.discourse-cdn.com/v4/letter/m/a9a28c/32.png) [@migandhi](https://forums.percona.com/u/migandhi)\
**Post date:** [December 6, 2006, 2:48am UTC](https://forums.percona.com/t/join-issue/140/1 "2006-12-06T02:48:44Z")

</div>

is the join that may be LEFT OUTER or RIGHT OUTER or INNER or just JOIN the same as in MSSQL .  
i am particularly interested in LEFT OUTER JOIN .

And i dont dare to use GROUP BY or DISTINCT as the query takes too long in execution.

My issue is proper migration from MSSQL to MySQL , which is becoming difficult at each step.

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [December 6, 2006, 6:29am UTC](https://forums.percona.com/t/join-issue/140/2 "2006-12-06T06:29:28Z")

</div>

JOIN semantic is the same, however query execution can be quite different - MySQL only supports nested loops join method which can be inefficient for complex queries.

Also note MySQL does not support FULL OUTER JOIN (LEFT/RIGHT are OK)