join types in sql

  • The clause to combine JOIN data in SQL

    The clause to combine JOIN data in SQL

    in sql, the join clause is used to combine records from two or more tables in a database using common values ​​from each table.
  • INNER JOIN in SQL

    INNER JOIN in SQL

    inner join in sql is the most important and often used join type.
  • LEFT JOIN in SQL

    LEFT JOIN in SQL

    the left join in sql is the type of join that returns all records from the left table and matching records from the right table.
  • RIGHT JOIN in SQL

    RIGHT JOIN in SQL

    right join in sql is a type of join that returns all records from the right side table and matching records from the left side table.
  • FULL JOIN in SQL

    FULL JOIN in SQL

    full join in sql returns all records in the left table and the table must combine and fill in that null values ​​for values ​​do not match.
  • SELF JOIN in SQL

    SELF JOIN in SQL

    each join operation must have two tables, but there are cases where you have to perform join on the same table, but you can call this join operation self join.
  • CARTESIAN JOIN in SQL

    CARTESIAN JOIN in SQL

    cartesian join in sql returns the cartesian product of record sets from two or more combined tables.