It is possible to create a nested SQL query for a report?

[Paul_Atreides]

Hello to everybody. I am newby on this forum but I have been working with iX-Developer for about two years. I am wondering if it is possible to do a nested SQL query in a .xls template in order to create a report in Excel. I´ve been studying some examples about xls template but I never seen a nested query, it is possible to do that? If it is possible please give one example to get the idea.
My thanks in advance.

[Russ C.]

A nested query as in

Code: Select all

SELECT id FROM users WHERE id IN (SELECT DISTINCT user_id FROM user_orders)?