This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes  Query Dependent on first Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark " Query Dependent on first" Watch " Query Dependent on first" New topic
Author

Query Dependent on first

Sanjay Deshpande
Ranch Hand

Joined: May 22, 2001
Posts: 111
I have a resultSet
RS1=Select Mainid ,SubId From Table1
i want to get values of SubId from another table2
Depending upon the values i get from RS1
i want to run rs2.
i m not getting the RS2 resultset.
Any solution?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Query Dependent on first
 
Similar Threads
copying the contents of Resultset object to another
junk characters for byte charset
Transactions
ResultSet Question
Problem in viewing records ?