Home » Developer & Programmer » Reports & Discoverer » need help for my question (oracle 9i)
need help for my question [message #476112] Tue, 21 September 2010 08:04 Go to next message
babuprasad02
Messages: 1
Registered: September 2010
Location: chennai
Junior Member
hi folks,


I having 3 tables

one is java,sql,test.

java contains 2 fields i.e., name and mark
name mark
a 25
b 15
c 05
d 10
e 20
sql contains 2 fields i.e., name and mark
name mark
a 25
b 15
c 05
d 10
e 20
test contains 2 fields i.e., subject and passmark
subject passmark
java 20
sql 20

i need a two queries one to find who are all passed in both subjects and who are all failed in both subjects.

condition: do not hardcode any values and dont use any subqueries
simply use the 3 tables and give the queries.

Thanks & regards

babuprasad
Re: need help for my question [message #476118 is a reply to message #476112] Tue, 21 September 2010 08:36 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
First prove us that you have passed Oracle sql
Wink

What you have tried so far for getting this output ?
And you can expect so many replies like ...
1) Please follow forum guide lines
2) We can`t do home works
etc...

So first follow the Forum guide lines...
And copy and paste your session of what you tried to get your desired output Smile

Good luck

sriram
Re: need help for my question [message #476119 is a reply to message #476118] Tue, 21 September 2010 08:39 Go to previous message
cookiemonster
Messages: 10860
Registered: September 2008
Location: Rainy Manchester
Senior Member
Also considering the fact that you've got table names stored in a column in another table I don't see anyway of doing this without any hard-coding of values. So the question is garbage.
Previous Topic: Discoverer divide by zero
Next Topic: Cannot write to file
Goto Forum:
  


Current Time: Fri Aug 01 17:48:54 CDT 2014

Total time taken to generate the page: 0.08016 seconds