Home » SQL & PL/SQL » SQL & PL/SQL » Either Joins1 or join2 but not both
Either Joins1 or join2 but not both [message #342882] Mon, 25 August 2008 07:50 Go to next message
friendarora
Messages: 24
Registered: February 2007
Junior Member

Hi all,

I have a requirement in which i need to execute either resource=emp.res or resource=mgr.res but if i apply or condition both will get executed. I need to find the resources under employee and if and only if not fouond we need to find the resource under manager. manager will always have a resource
Re: Either Joins1 or join2 but not both [message #342886 is a reply to message #342882] Mon, 25 August 2008 07:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please reread your post.

Do YOU think this is clear?
Re: Either Joins1 or join2 but not both [message #342891 is a reply to message #342886] Mon, 25 August 2008 07:58 Go to previous messageGo to next message
friendarora
Messages: 24
Registered: February 2007
Junior Member

The condition is for the execution of
join1 resource=emp.res
or
join2 resource=mgr.res

join2 will be excuted only if join1 returns no rows. Other wise the output should have rows from join1 only
Re: Either Joins1 or join2 but not both [message #342909 is a reply to message #342891] Mon, 25 August 2008 08:29 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
ribbit clump sump thrrrppppph.
Hope this helps, if it doesn't, then if you read the forum guidelines, they might help you communicate your problem more clearly.

[Updated on: Mon, 25 August 2008 08:30]

Report message to a moderator

Re: Either Joins1 or join2 but not both [message #342911 is a reply to message #342891] Mon, 25 August 2008 08:30 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please stop grading your own post.
Re: Either Joins1 or join2 but not both [message #342935 is a reply to message #342909] Mon, 25 August 2008 10:32 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ribbit clump sump thrrrppppph.
Hope this helps

Laughing

Michel
Previous Topic: Transfering files from one location to another location
Next Topic: Getting lot of invalid object
Goto Forum:
  


Current Time: Fri Dec 09 05:36:26 CST 2016

Total time taken to generate the page: 0.09741 seconds