Matching records from different tables that contain dissimilarities

[LBB]

I'm attempting to match two slightly dissimilar text
fields.

I have 2 similar tables. Each contains records of
companies, with fields such as COMPANY_NAME,
PRIMARY_CONTACT, ADDRESS, PHONE...etc. One table (Table B)
has 2,700 records and is a much smaller subset of the
other table (Table A), which has 93,000 records. The
smaller table WAS NOT created from the larger table and
they do not share common unique identifiers. Although both
tables are company listings, the data come from different
sources.

Note:

Table A contains numerous COMPANY_NAME field duplicates.
Table A has two fields that Table B does not have (field x and field y).
The tables have only 1,586 exact COMPANY_NAME field

matches, but I know that nearly all of the 2,700 companies
listed in table B are also companies that are listed in
table A. The problem seems to be that there are many ways
to spell company names, so there are few exact matches.

My problem is as follows:

I want to create a new table (table C).
Table C would contains all table B company records that

correspond to table A company records and I need the x and
y fields (containing data) from table A in the new table C.

Thanks

LBB