I have a query extracting information from three tables.
Table1 has 21,000 security numbers
Table2 has 50,000,000 security numbers and account numbers
Table3 has a OCCD field for each account number
Problem is after extracting the information there is over 40,000,000 records coming back.
The query keeps freezing on me. How can I run a query that only returns the subtotals for each OCCD field ? Meaning the new query should come back and tell me how many accounts for each OCCD.
Table1 has 21,000 security numbers
Table2 has 50,000,000 security numbers and account numbers
Table3 has a OCCD field for each account number
Problem is after extracting the information there is over 40,000,000 records coming back.
The query keeps freezing on me. How can I run a query that only returns the subtotals for each OCCD field ? Meaning the new query should come back and tell me how many accounts for each OCCD.