I have a couple of tables like so:
FName FInitial
SName SName
Address1 Address1
Address2 Address2
Address3 Address3
Zip Zip
Phone
I need to match the phone numbers to the addresses in table 1.
Trouble is, Table 1 has data like:
Joe, Bloggs, 25 Frontier St,, BigTown, 12345
Mary, Bloggs, 25 Frontier St,, BigTown, 12345
James, Bloggs, 25 Frontier St,, BigTown, 12345
Table 2 would only have
Joe, Bloggs, 25 Frontier St,, BigTown, 12345, (111) 555-1234
So... I need to get any matches on table 1 and then populate them to the
rest of the family at the address. So in the example above, Mary would
also get a phone number - I only have a first initial in table 2, so
that would hot Joe and James.
Any thoughts on a strategy to do this? If I need to go outside MySQL to
do some programming I'd be using php5.
Thanks for any pointers.
Russell.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
