Jump to content

Difference between Left Join and Right Join!


Guest Mark83

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...