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.

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)