Subject: Re: mySQL question/help
From: Arthur Corliss (arthur@corlissfamily.org)
Date: Fri Sep 27 2002 - 06:31:54 AKDT
On Thu, 26 Sep 2002, Scott Johnson wrote:
>
> I'm wanting to combine certain colums from different databases into a single db..... Namely the TaxID from db2 and DateOfBirth from db3 into db1.
>
> I would need to have the LastName, FirstName, & MiddleName colums from all db's compared, and if matched, produce a hit and combine the data/record.
>
> IS THERE ANY EASY OR AUTOMATED WAY TO DO THIS?????????????????????????????????
>
> I'm guessing this is a lost cause but thought I might get lucky.
>
> Ideas? Comments? Flames welcome....
You can easily do this in SQL with inner joins, which, if I recall correctly,
is fully supported in MySQL.
--Arthur Corliss
Bolverk's Lair -- http://arthur.corlissfamily.org/
Digital Mages -- http://www.digitalmages.com/
"Live Free or Die, the Only Way to Live" -- NH State Motto
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Fri Sep 27 2002 - 07:16:54 AKDT