Skip to main content

Posts

Showing posts with the label Sql server Right Outer Join

What is Full Outer Join in SQL? Why you use?

What is Full Outer Join in SQL? Why you use? FULL OUTER JOIN work between with both the Joins  LEFT OUTER and RIGHT OUTER. If the condition is matched then returns matched rows otherwise returns NULL values. I hope you are enjoying with this post! Please share with you friends!! Thank you!!!

What is Right Outer Join in SQL? Why you use?

What is Right Outer Join in SQL? Why you use? In the RIGHT OUTER JOIN , returns all the matched rows from the right table and matched rows from left table. If the left table rows are not matched then return NULL values. I hope you are enjoying with this post! Please share with you friends!! Thank you!!!