0

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 ?

Community
  • 1
  • 1
Jagan
  • 4,289
  • 19
  • 58
  • 70

2 Answers2

4

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

Mostly it's a convenience thing.

EmFi
  • 23,295
  • 3
  • 56
  • 68
1

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

Amber
  • 477,764
  • 81
  • 611
  • 541