The SQL joins used to combine records from two or more tables in a database. A join is a means for combining fields from two tables by using values common to each. There are different types of joins available in SQL like as self-join, inner-join, left-join, and right-join.
Self-join: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement.
Inner-join: INNER JOIN return all rows from multiple tables where the join condition is match.
Left-join: The LEFT JOIN keyword returns all the rows from the left table (tbl_T), even if there are no matches in the right table (tbl_T1).
Right-join: returns all rows from the right table, even if there are no matches in the left table.
Consider the following two tables.
Table : tbl_T
Join the conversation! Your thoughts help the community grow.