• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Nested Record sets and Joins

 
Reggie McDougal
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can some one give me a hand with my code.

I have 2 tables

Product Table
phonepricevalue table

I want to get the product name from the product table store it in an ArrayList and then pull the data from the phonepricevalue that corresponds to the product name and store that in the same Array.

Now what is the best way to create a join in my ArrayObject

1. Do I have sperate method method 1 get the name and ID create the Array and pass in into the next method to pull the data for each plan.

2. Do it with SQL some how that will let me jion the data and store it in the Array in one operation.

I'm using Oracle 8i weblogic 8.1

Cheers

Reg


 
Reggie McDougal
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this is all I needed to do


[ January 10, 2005: Message edited by: Jeanne Boyarsky ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35269
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Reggie,
Thanks for posting the solution!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic