Using Table to Select Records from Larger Table with Join

  • Thread starter Thread starter Bev
  • Start date Start date
B

Bev

I am attempting to select records from a very large database by using a table
with member ids joined to the larger tables with the same field. The Select
table residess in the database, the larger table is linked to ODBC. I am
creating a table from the matching records.

When I run this, it never completes. The select table has approximately
6000 records.

Is there a better way to accomplish this?
 
"NEVER" completes, or you just get sick of waiting? Cut your select
table to 1 record, and see if it runs.

How large is this very large database? Is your memberID an indexed
field in both tables?

If you post your SQL, someone smarter then myself can look it over and
see if there is a more efficient way to accomplish the task...

Phil
 
I am attempting to select records from a very large database by using a
table with member ids joined to the larger tables with the same field.
You might have a Cartesian effect. Did you join them in your query?
 
Back
Top