What are the different types of joins? Explain with example

4 types of joins:
      a. Inner Join: Used to combine records from 2 tables wherever there are
      Matching values in common field.
      b. Outer Join: Join all the records in one table even if there are no matching Values in the joined field from the second table.
      c. Exists Join: Combine records from one table wherever there exists a value  in a common field in another table.
      d. Non-exists join: Combine records from one table wherever a value in a
      Common field in another table does not exist.