Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

What is the difference between outer join and inner join ?

You use INNER JOIN to return all rows from both tables where there is a match. i.e. in the resulting table all the rows and columns will have values.

In OUTER JOIN the resulting table may have empty columns. Outer join may be either LEFT or RIGHT

LEFT OUTER JOIN returns all the rows from the first table, even if there are no matches in the second table.

RIGHT OUTER JOIN returns all the rows from the second table, even if there are no matches in the first table.

5 comments:

  1. Most people don't have that willingness to break bad habits. They have a lot of excuses and they talk like victims. See the link below for more info.

    #excuses
    www.matreyastudios.com

    ReplyDelete
  2. Excellent and decent post. I found this much informative, as to what I was exactly searching for. Thanks for such post and keep it up.


    www.gofastek.com

    ReplyDelete
  3. Best blog.Got to learn new things.Thanks for this Blog SAP HR Training in Chennai

    ReplyDelete
  4. Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about SAP BASIS.SAP basis

    ReplyDelete

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget