tags: #sql #public #sql-join
Rows that have matches(eg left.id = right.id) in both left and right table are selected.
!SQL - Inner Join.png
All rows in left table are selected. If there are matches in right table they are joined.
!SQL - Left Join.png
All rows in the right table are selected. If there are matches in the left table they are joined.
!SQL - Right Join.png
All rows in left and right tables are selected. If there are matches rows are joined. If there are no matches, the rows are still included while leaving the other side empty.
!SQL - Full Join.png