Good people, I have here two tables with the following structure:
1 - Orders, 2 - Order_items.
I need to select the data of each and display the details of the purchase, for example:
Home
Order # 1 (table 1)
Client: Thales (table 1)
Snacks: snack1, snack2, snack3 (table 2) (value of each snack of table 2)
Address: Customer address (table 1)
Payment: Payment (table 1)
Status: Received (table 1)
Total: total value (calculate from table 2)
How could I do this? I've made several attempts, but I'm not able to display correctly.