lookup standard data

[odun]

Hello all:

I have a table in access with a few fields. One of the fields is a name field, but the names are not standardized. I have another table with 1 column, and this contains standard names, and these names are not duplicated.

e.g.
Table 1
Name
Evian Corp
Evian Ltd
Evian Incorporation
IBM Inc.
IBM
IBM Corporation
MacDonalds
MacDonald's
MacDonald Inc.

Table 2
Standard Name
Evian
IBM
MacDonalds

I would like to match the name in table 1 by the first 4 letters of the name in table 2. I would like to create a query with 2 columns, Name from table 1 and Standard name from table 2.

Is this possible?

Please help, this is urgent.

Thanks much