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,649
  • 19
  • 60
  • 70

2 Answers2

4

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

Mostly it's a convenience thing.

EmFi
  • 23,435
  • 3
  • 57
  • 68
1

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

Amber
  • 507,862
  • 82
  • 626
  • 550