Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
    Bookmark Topic Watch Topic
  • New Topic

SQL problem

 
Jackie Wang
Ranch Hand
Posts: 315
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 1365
  • Mark post as helpful
  • send pies
  • Report post to moderator
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.
 
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!