ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  SQL Subqueries
Subject:   SubQueries
Date:   2003-02-27 17:51:37
From:   john1948
I have 2 sql tables.
(1) One Table contains single part numbers. In this table the part numbers are unique.
(2) The Second table contains multiples of the single part number in the first table. This table contains values in the second part record that I need to access. I have written a procedure to get at this data in a cursor. This cursor however take over 6 minutes to update the 1st table. The second issue is that the first table only contains about 3,000 records. I see no easy way of accessing this second record.
Do you?



1 to 1 of 1
1 to 1 of 1