why do i need left outer join if i have right outer join ?

Question

Possible Duplicate:
When or why would you use a right outer join instead of left?

What ever the functionality i get with left outer join i can get it by interchanging table names.Then, what is the need for having two outer joins ( left and right) ? If there is any specific need can some body explain with an example ?

Answer 1

They're the same thing, use whichever makes more sense to your mind when reading the query.

Answer 2

Why do we use >= when < does the same thing?

Mostly it's a convenience thing.