join vs right join vs left join in sql

SQL INNER JOIN returns the rows from the tables that have matching value in columns.