Jump to content

Difference between Left Join and Right Join!


Guest Mark83
 Share

Recommended Posts

The difference between a left and right join is which table all of the records are selected from. If you do a left join, then the records in the "left" table are all returned and only matching records from the "right" table are returned. If you do a right join then all records in the "right" table are returned and only matching records in the "left" table are returned. If you do this:A JOIN BThen A is the "left" table and B is the "right" table.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...