This has to be easier than I am making it. I am trying to run a very simple query that uses a left join on two tables. Table 1 contains serial numbers. Table 2 also contains serial numbers. However, the serial numbers in Table 2 are always longer than those in Table 1. For example:
Table 1 = 1234567
Table 2 = WD1234567
Table one has 5,000 records, and table 2 contains 100,000 records. Below is the SQL Statement for the Query I am using:
Code:
SELECT [Table1].[Lot No], [Table1].[Serial No], [Table2].[Serial Number]
FROM [Table1] LEFT JOIN [Table2] ON [Table2].[Serial Number] LIKE * & [Table1].[Serial No] &*
WHERE ((([Table1].[Lot No])="ABCDE"));
.
If I run the query without the "Like" Operator and wildcard in the statement, it runs fine. But, it does not contain all of the results I need. When I run it with the "Like" and wildcard, Access begins the query, returns results, and then begins to cycle between not responding and and running. I have let it run for a considerable amount of time (1 hr) assuming that it was taking a long time to go through all of the records. However, the cycle never stopped.
Any help would be great.