iX Talk

Posted: **Wed May 14, 2014 7:36 pm**

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.

Posted: **Wed Jan 22, 2020 3:01 pm**

A nested query as in

Code: Select all

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

iX Talk

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

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

Re: It is possible to create a nested SQL query for a report