| need help for my question [message #476112] |
Tue, 21 September 2010 08:04  |
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 #476119 is a reply to message #476118] |
Tue, 21 September 2010 08:39  |
cookiemonster
Messages: 13920
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
