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 | Blog