Inner Join vs Left Join
View Single Post
08-05-2008, 02:26 PM
Join Date: Nov 2007
not quite, If i remember correctly the left join returns all records when the first table (or the left one) has a value that is not null and still meets the conditions of the ON clause. And the Inner join returns when both of them are not null. Outer returns all rows as long as one of them is not null and right does the opposite of left.
Pretty sure thats how it works.
iSearchNotes.com - Share College Student Notes
View Public Profile
Send a private message to CoryMathews
Visit CoryMathews's homepage!
Find More Posts by CoryMathews