Multiple 'NEST' statements in select query,

Am trying to use multiple ‘NEST’ statements in one select query. When I have both in the query, I get no results. When I use either one by themselves, I get correct results. Both nests key off the same field form the anchor part of the query (entityId).
Are multiple ‘NEST’ statements not valid to use?

select *
from devtn siteinfo
NEST devtn relations
ON  relations.kind='siteinfoRelationship'  and relations.kindVersion='6.0.0' and relations.entityId=siteinfo.entityId
NEST devtn blogs
ON  blogs.kind='siteinfoBlog'  and blogs.kindVersion='6.0.0' and blogs.entityId=siteinfo.entityId
where siteinfo.kind='siteinfo' and siteinfo.kindVersion='6.0.0' and siteinfo.status='active'

fyi, query was wrong, needed LEFT OUTER NEST to make them operate independently

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.