What is the difference in using inner join and outer joins?
Inner join: It is is the most common type of join. Inner joins return all rows from multiple tables where the join condition is met. Outerjoin: This type of join returns all rows from one table and only those rows from a secondary table where the joined fields are equal (join condition is met).Here a (+) operator is uses for additional information of given table.
