Unfortunately, what you're trying to achieve is only possible with SQL query based tables.
You can take a look at this thread, for example, and see how you can do it. We do not provide support for writing custom queries, so we can't help you with this.
How do I merge to tables that I created through SQL Query?
Hi Martin
Thank you for reaching out to us.
Unfortunately, what you're trying to achieve is only possible with SQL query based tables.
You can take a look at this thread, for example, and see how you can do it. We do not provide support for writing custom queries, so we can't help you with this.
Noted.Thank you.
You are most welcome
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!