Home » RDBMS Server » Server Administration » limiting in the where criteria while using an outerjoin
limiting in the where criteria while using an outerjoin [message #371009] Mon, 07 August 2000 16:53 Go to next message
Ed
Messages: 24
Registered: November 1999
Junior Member
I was sent a code with a right outerjoin. Within the same where clause, other criteria was listed. (i.e. amount >$100.

My question is: Can use other limiting criteria in a where clause when you are using an outerjoin?

Thank You

Report message to a moderator

Re: limiting in the where criteria while using an outerjoin [message #371018 is a reply to message #371009] Wed, 09 August 2000 01:47 Go to previous message
Vjeko
Messages: 15
Registered: August 2000
Junior Member
If you're using outer joins you can use other where criteria. But, there are certain rules:
- each column in outer-join table must have (+) sign in where clause
- if you have more than one outer join tables, each of then must be joined with a table without outer joins. Two tables with outer joins can't be joined together.

Good luck!

Report message to a moderator

Previous Topic: Re: Help on SQL "SELECT.."
Next Topic: Re: How to find the 4th maximum sal?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 03 22:06:51 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.