mySQL question/help


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