How to use SQL JOIN?

JOINs bind 2 or more tables according to specified columns.

Types of joins:

• Equijoins
• Outer joins: FULL OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, +
• Inner joins
• Self joins (recursive joins)
• Hierarchical joins: START WITH ... CONNECT BY PRIOR
• Natural joins