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 error

Received Response
3
Views
3
Comments
edited Sep 3, 2017 6:24PM in Integrations and APIs 3 comments

Content

Hi,

i am trying to get products and categories in a single query. i was performing below query but always getting error "too many source tables in query" please help.

select a.LookupNameory, b.LookupName from ServiceCategory a, ServiceCategory b where a.ID=b.Parent;

Thanks

Prasad

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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