Joins in database, We can easily determine the meaning of joins very easily. In database we use the concept of joining in tables to fetch the data combination. There are different type of methods of joining two or more than two tables in database. You can categories joins in two simple types. one is inner join and outer join. We are here to discuss the outer joins only. Lets discuss the outer joins.

Outer joins are useful to get the records if it does not match with other table records. It means joined table will retains all the records if matching records not available. Lets take an small example. Suppose we have two table one is emp and other is salary.
Emp

Salary

You can create mysql query for joining these two tables with outer join.

SELECT * from emp as e LEFT OUTER JOIN salary as s on s.Id=e.Id