Subject: Re: mySQL question/help
From: Scott Johnson (sjohnson@gci.net)
Date: Thu Sep 26 2002 - 22:51:17 AKDT
Yes, as was already pointed out, I realize I have 3 seperate mySQL db's...
not 2. :\
Scott
----- Original Message -----
From: "Scott Johnson" <sjohnson@gci.net>
To: <aklug@aklug.org>
Sent: September 26, 2002 22 41
Subject: mySQL question/help
> I have 2 seperate mySQL db's I need to semi-merge....
>
> Here's the column list.....
>
> db1:
> RecordID
> LastName
> FirstName
> MiddleName
> Address1
> Address2
> City
> State
> ZIP
>
> db2:
> RecordID
> LicenseNum
> TaxID
> LastName
> FirstName
> MiddleName
> BusinessName
> Address
> City
> State
> ZIP
>
> db3:
> RecordID
> RecordStatus
> Address1
> Address2
> City
> State
> ZIP
> DateOfBirth
> FirstName
> LastName
> MiddleName
>
> Here's my point/question/idea...
>
> 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....
>
> Scott
>
>
> ---------
> To unsubscribe, send email to <aklug-request@aklug.org>
> with 'unsubscribe' in the message body.
>
>
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Thu Sep 26 2002 - 22:51:21 AKDT