SQL Joins Query.

  • A JOIN clause in SQL, is used to combine rows from one or more tables, based on column between them.
  • Types of Joins -
    • Inner Join
    • Left Join / Left Outer Join
    • Right Join / Right Outer Join
    • Full Join / Full Outer Join