You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error: too many source tables in query

Accepted answer
44
Views
6
Comments
edited Jun 8, 2022 11:55AM in General Technical Discussions 6 comments

Content

Hello All,
I tried to create a complex query but I got "too many source tables in query".
Then I attempted to reduce the problem but I still get the same error when I only use two tables.
I have the following query:
SELECT SC.LookupName AS level1 FROM ServiceCategory SC, Answer A WHERE A.Categories.ID = SC.ID AND A.Categories.ID = 70
When I run it in Connect Object Explorer I get "too many source tables in query".

Does anyone know why this happens?
How do I get around it?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!