Query data pull takes FOREVER

[CS45]

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]

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]

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