Display data from a joined table

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
theyland
Posts: 12
Joined: 2020-11-04 15:43

Display data from a joined table

Post by theyland » 2020-11-07 17:05

Hello still new here.
How could I display data in one table which comes from two different tables which are linked via a join statement?

I have one table 'payments' and another table called 'customers'. These 2 tables have the CustomerID field in common. I would like to display all payments together with the Customer Names.

Thanks
Thomas

Post Reply