say there are two table License, Item license has column (lic_name, lic_no, create_date) Item has column(lic_no, item_description) lic_no join 2 table
i want to write a file which contain license and Item according to the license i.e. license A Item I Item II license B Item III Item X license C Item IV I have 1 access to DB for getting the license and then I have access to 3 DB for getting the item according to each license. Are there a way to grab all Items first? I am not famliar with the resultset to help the performance? Please help. ^_^ Thanks! =)
David Weitzman
Ranch Hand
Joined: Jul 27, 2001
Posts: 1365
posted
0
I'm not sure what "I am not famliar with the resultset to help the performance?" is supposed to mean. Either you want to optimize the SQL or figure out how ResultSet works. Both of those are best done in the JDBC forum. Since this is pretty much a duplicate of a post in the JDBC forum, please continue the conversation there.
0
