The Little Guy Posted November 9, 2010 Share Posted November 9, 2010 What is a better join type to use, and why? - Left Join - Inner Join - Right Join I like to use Left Join, but is that the way to go? Link to comment https://forums.phpfreaks.com/topic/218245-left-vs-inner-vs-right-join/ Share on other sites More sharing options...
ManiacDan Posted November 9, 2010 Share Posted November 9, 2010 They serve different purposes, see the manual entry for left v right joins. -Dan Link to comment https://forums.phpfreaks.com/topic/218245-left-vs-inner-vs-right-join/#findComment-1132447 Share on other sites More sharing options...
fenway Posted November 12, 2010 Share Posted November 12, 2010 Yeah, but never use RIGHT -- you can always re-write it a LEFT join, and that's just the convention. Link to comment https://forums.phpfreaks.com/topic/218245-left-vs-inner-vs-right-join/#findComment-1133527 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.