I have two tables, The first table is a transaction table and the other one is a list of part numbers (thousand of parts numbers in the table).
I need to query these two tables by connecting them with part number fields. My problem is the part numbers in the other table is not correctly formatted.
Is there a way to run query from the two tables by using wildcard query from the other table?
Any advice or help would be much appreciated.
Many Thanks,
Iwanto
I need to query these two tables by connecting them with part number fields. My problem is the part numbers in the other table is not correctly formatted.
Is there a way to run query from the two tables by using wildcard query from the other table?
Any advice or help would be much appreciated.
Many Thanks,
Iwanto