Display data from a joined table
Posted: 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
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