Hi,
I'm having intermittent problems with a big query where I grab about 30
fields from 4 tables.
I've snipped my query:
Select ... Status_Msg from Extracts, Transacts, Publisher, Status where (
Transacts.ID=33237 and
Extracts.Pub_ID=Publisher.ID and
Transacts.Status=Status.ID and
How large is the status table? I would recommend trying to reduce the
inital recordset of your largest table with a subquery and then joining
the subquery to the other tables. Could you please show me the full query
with the table
sizes?
Jake Johnson
[EMAIL PROTECTED]
http://www.plutoid.com