Using Table to Select Records from Larger Table with Join

[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?

 

[Phil Smith]

"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

 

[KARL DEWEY]

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?