Difference between joins

  1. INNER JOIN: An inner join which is equal to queries of two tables ; they will have two rows common
  2. Left outer join :
    This join will give you all rows in A and if any row found common in B column.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.