MySQL Forums
Forum List  »  Newbie

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...

Options: ReplyQuote


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.