SQL joins are a very common technique to build queries in databases. There are three types of joins: Inner, Left, and Right.
- Inner join - This is the most common type of join in SQL. It matches all the rows from one table with all the rows from another table where there is a match between values of columns that appear in both tables.
- Left join - A left join matches all the rows from one table with all the rows from another table where there is a match between values of columns that appear in both tables, but not matching values on columns that do not appear in both tables.
- Right join - A right join will match all the rows from one table with all the rows from another table where there is a match between values of columns that appear in both tables.
Share a personalized message with your friends.