Trying to compare info in two tables based on partial number match

[tbucha3]

I have two tables that I have to get information from to produce another table. Both tables come from separate resources, one has partial accounts with addresses and the other has complete account numbers with names. I need all of the information on one report and I'm struggling to write an SQL to do a partial number match.

Table1
ACCT Address
123 123 street
789 15 crescent

Table 2
Acct Name
12345 Tom
6789 Tim

Output Required
Acct Name Address
12345 Tom 123 street
6789 Tim 15 crescent


Any help would be appreciated.

[Nathan H]

I have two tables that I have to get information from to produce another table. Both tables come from separate resources, one has partial accounts with addresses and the other has complete account numbers with names. I need all of the information on one report and I'm struggling to write an SQL to do a partial number match.

Table1
ACCT Address
123 123 street
789 15 crescent

Table 2
Acct Name
12345 Tom
6789 Tim

Output Required
Acct Name Address
12345 Tom 123 street
6789 Tim 15 crescent


Any help would be appreciated.

SELECT Table1.Acct, Table1.Name, Table2.Acct, Table2.Name, Table2.Address
FROM Table1, Table2
WHERE (((Table1.Acct)=Mid([Table2.Acct],1,3))) OR (((Table1.Acct)=Mid([Table2.Acct],2,3)));