MySQL JOIN – (INNER JOIN)
query
result
description
characteristics:
sequence – dos not matter
chaining – dos not mater
MySQL LEFT JOIN – (LEFT OUTER JOIN)
query
result
description
MySQL RIGHT JOIN – RIGHT OUTER JOIN
query
result
description
MySQL FULL JOIN – FULL OUTER JOIN
MySQL engine does not support outer join / full outer join. There fore to make table connection you need to use LEFT JOIN, UNION and RIGHT JOIN With exclusion of NULL.
query
result
description
LEFT EXCLUDING JOIN
query
result
description
RIGHT EXCLUDING JOIN
query
result
description
OUTER EXCLUDING JOIN
query
result
description