Page 1 of 1

report with fields from different tables

Posted: 2021-09-11 19:22
by wferreira
Hello, I need to create a filter with data from different tables, how do I do
it?
Example:
customers table - name and phone
table value - salary

Re: report with fields from different tables

Posted: 2021-09-14 15:50
by pfrumkin
Hi,

Take a look at viewtopic.php?f=2&t=4449, perhaps get some ideas there. You create a dummy table, then you build the SQL to get the data from the original source(s) to this dummy table.

~Paul