using xtk.queryDef to get fields from a subquery?

Hi team,

It is possible to get the fields from a sub-query?

I have created a query so it joins two schemas, but I need to bring ALL fields from main and sub schemas, is that possible?

Regards,

Raúl

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Jonathon_wodnicki

Hi,

It's not possible to select fields out of where clause subqueries, no.

You can join the subquery's tables instead though.

Thanks,

-Jon

Accepted solution

Community Advisor

Hi,

It's not possible to select fields out of where clause subqueries, no.

You can join the subquery's tables instead though.

Thanks,

-Jon

Sign up