OraFAQ Forum: Server Administration » limiting in the where criteria while using an outerjoin

Home » RDBMS Server » Server Administration » limiting in the where criteria while using an outerjoin

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

limiting in the where criteria while using an outerjoin [message #371009]

Mon, 07 August 2000 16:53

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:59:25 CST 2024