Error: too many source tables in query
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?