inner join allows you to retrieve data from multiple tables which match the join conditions. while outer join returns all rows from one table and only those rows from a secondary table where the joined conditin match