Re: UPDATE Table 1 with JOIN Table 2
Posted by:
kate W
Date: August 02, 2015 06:20PM
I solved that problem! But I have a new one:
I have a table with 1 million or so entries comprised of duplicate individuals (some folks go to prison more than once. Go figure). I want to create a table that only includes the earliest entry for each individual.
Each individual has a unique ID number (idno), which would appear multiple times in the table. And each row of data has a "date of entry" (admidt_dt).
I've tried to find a similar problem in the online forums. But I'm so new to this I can't tell if any get close to answering this problem...
Subject
Written By
Posted
Re: UPDATE Table 1 with JOIN Table 2
August 02, 2015 06:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.