Query data pull takes FOREVER (1 Viewer)

CS45

Member
Local time
Today, 03:44
Joined
Jun 17, 2020
Messages
38
Check the SQL statements. Do they both have the same number of table sources in the FROM clause?

It says that the query only pulls from one linked table...I keep getting missing expression errors in my pass through version of the select query.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 00:44
Joined
Oct 29, 2018
Messages
21,454
It says that the query only pulls from one linked table...I keep getting missing expression errors in my pass through version of the select query.
Unfortunately, it would be hard to offer any meaningful suggestions without seeing the SQL statement you're using. Are you not able to share even the actual error message?
 

isladogs

MVP / VIP
Local time
Today, 08:44
Joined
Jan 14, 2017
Messages
18,209
There are many things that can cause a query to run slowly.
If you are unable to post your query design, all any of us can do is make educated guesses based on previous experience.

You may find this article useful: Optimise Queries
 

Users who are viewing this thread

Top Bottom