Subject: mySQL question/help
From: Scott Johnson (sjohnson@gci.net)
Date: Thu Sep 26 2002 - 22:41:12 AKDT
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.
This archive was generated by hypermail 2a23 : Thu Sep 26 2002 - 22:41:15 AKDT