"yanky" <yanky9***@yahoo.com> wrote in message
news:1171635947.471997.170150@q2g2000cwa.googlegroups.com...
>   We have 4 different databases, each with one or two company/contact
> tables of its own.  We are looking for a tool to 'run' thru the
> tables(say company) and create a seperate table with all the linkage.
> We are looking to match on phone, address, company name.  I know we
> could do a number of 'like' statements and review, but if there is a
> tool out there, it may be more cost effective.  Example:
>
> db1.companytable.name -> db1.companytable.co_ID(Accounting info)
> db2.companytable.name -> db2.companytable.co_ID(Service issue info)
> db3.companytable.name -> db3.companytable.co_ID(Order info)
> db4.companytable.name -> db4.companytable.co_ID(Additional demographic
> data)
>   end result record
> db1tablelink                      db2.tablelink
> db3.tablelink            db4.tablelink
> db1.cotable.co_ID             db2.cotable.co_ID
> db3.cotable.co_ID    db4.cotable.co_ID
> db1.cotable.co_ID             no match(NULL)
> db3.cotable.co_ID     db4.cotable.co_ID
> db1.cotable.co_ID             db2.cotable.co_ID       no
> match(NULL)       db4.cotable.co_ID
>
> We would also maybe to a data of the newest data...  then when
> querying for company, it looks at the above table and pulls certain
> data from each top tables, say ACCT info, Service issue info, etc.
>
> Again, we could probably write something ourselves with likes and come
> up with a rating system to say, address matches exactly, but name and
> phone are close...  some db have ABC Company or ABC Co.
>
> thanks,
> yanky
>