Difference between joins
- INNER JOIN: An inner join which is equal to queries of two tables ; they will have two rows common
- Left outer join :
This join will give you all rows in A and if any row found common in B column.
- Full outer join:
This is union of A and B. all rows found in A and B . and if any query in A does not match anywhere in B then B the specified portion will be void.
- REGULAR JOIN :
regular join which brings all records of matching rows and we do not use any kind of inner, outer, right or left joins. etc.
- Cross joins -cross join also called cartesian product . it will return each row found in left table with all rows in right table.you can conclude left table to itself.
- RIGHT JOINWe use RIGHT JOIN when we want to get all the rows found in left table and with and adding of unmatched rows found in right table.
- LEFT JOINWe use LEFT JOIN when we want to get all the rows found in left table and with and adding of unmatched rows found in left table.