Inner joins & Outer joins

Join is used to combine rows from multiple tables. A Join is performed whenever two or more tables are listed in the From clause of an SQL Statement.

a.     INNER JOIN- Inner joins return all rows from multiple tables where the JOIN condition is met.

E.g. Select Suppliers.SuppId,Suppliers.SuppName,Orders.OrderDt from Suppliers, Orders where Suppliers.SuppId=Orders.SuppId;

b.     OUTER JOIN-Outer Join returns all rows from one table and only those rows from secondary table where the joined fields are equal(Join condition is met)

           E.g. Select Suppliers.SuppId,Suppliers.SuppName,Orders.OrderDt from Suppliers, Orders where Suppliers.SuppId=Orders.SuppId(+);