hi All, I am currently dealing with a number of tables each with over 40,000 records. I have these tables in Access and i'm planning to do some SQL query on them.
The problem is that due to then large table size, the query is running extremely slow and I'm not sure if using Access SQL is the most viable option.
I have something like:
there are three tables, T1 , T2 and T3.
T1: T2 T3
ID Value ID Value ID Value
1 100 2 5 3 1
2 200 3 5 4 1
3 300 4 5
My job is to add up all the corresponding values in the three tables and come out with something like this :
So you see the three tables have different number of records and If a record in T1 is not found in T2 or T3, I still want to keep the original value in T1. And for each table there are some 10,000 records!!!
Any advice on how to go about doing this? Some other alternatives I cuold think of is to copy the three tables to Excel and use formula, but in reality I have large number of such files so doing it manually is very time consuming.