Pages

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)