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? Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.