using xtk.queryDef to get fields from a subquery? | Community
Skip to main content
RaulOcana
Level 3
Jun 11, 2019 7:49 PM UTC
Solved

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.
Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
Jun 12, 2019 4:53 PM UTC

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

1 reply

Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
Jun 12, 2019 4:53 PM UTC

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

Translate