SQL joins are used to combine data from two or more tables based on a related column.
Inner Join: Returns rows with matching values in both tables.
Left Join (or Left Outer Join): Returns all rows from the left table and matching rows from the right table. Non-matching rows in the right table will have NULL values.
Right Join (or Right Outer Join): Returns all rows from the right table and matching rows from the left table. Non-matching rows in the left table will have NULL values.
Full Join (or Full Outer Join): Returns rows with matching values from both tables and includes non-matching rows from both, with NULLs where there’s no match.