Expand my Community achievements bar.

SOLVED

using xtk.queryDef to get fields from a subquery?

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
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

View solution in original post

1 Reply

Avatar

Correct answer by
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