report with fields from different tables

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
wferreira
Posts: 9
Joined: 2018-09-14 01:18

report with fields from different tables

Post by wferreira » 2021-09-11 19:22

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

pfrumkin
Veteran Member
Posts: 147
Joined: 2020-02-18 17:58
Location: Albuquerque, New Mexico USA

Re: report with fields from different tables

Post by pfrumkin » 2021-09-14 15:50

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

Post Reply