Guest Mark83 Posted January 29, 2008 Share Posted January 29, 2008 Hello All,Can anyone explain me the difference between Left Join, Right Join? Please give me a detailed reply. Regards,Mark. Link to comment Share on other sites More sharing options...
aalbetski Posted January 29, 2008 Share Posted January 29, 2008 http://www.w3schools.com/sql/sql_join.asp Link to comment Share on other sites More sharing options...
justsomeguy Posted January 29, 2008 Share Posted January 29, 2008 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.