JOIN command in SQL
INER JOIN is a method for combining data from two or more tables based on a logical relationship. This operation creates a temporary result set by merging data from two tables according to a specified condition, including only the rows that have matching information in both tables.
Get Sheydamd’s stories in your inbox
Join Medium for free to get updates from this writer.
RIGHT JOIN returns all matching rows from the table as well as all rows, including non-matching ones, from the right table. In other words, RIGHT JOIN returns all records from the right table along with the records from the left table that match the right table.
LEFT JOIN is used to retrieve data from two tables while keeping all rows from the left table, even if there is no matching row in the right table. It returns matching records from right table and if no match in the right table, the result will contain NULL values for the right table’s columns.
