Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with Left/Right joins and OR

Status
Not open for further replies.
ThatRickGuy

ThatRickGuy

Programmer
Oct 12, 2001
3,841
US
Is there some type of inherent limitation on the use of OR boolean operators in the ON clause of Full/Left/Right Joins?

I have a query that returning significantly less data (only one side of the join) when I use two clauses in the ON with an OR. Running the query with either one of the two clauses individually returns the correct data though.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
[monkey]I believe in killer coding ninja monkeys.[monkey]
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
642
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
693
SkipVought
S
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
774
Andrzejek
Andrzejek
Rasheed Shaik
  • Locked
  • Question
\Orant\DBS\FMCUS.MSG not found
Replies
0
Views
887
Rasheed Shaik
Rasheed Shaik

Part and Inventory Search

Sponsor

Back
Top