Announcement

Announcement Module
Collapse
No announcement yet.

JOIN issue

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • JOIN issue

    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.

  • #2
    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)

    Comment

    Working...
    X