Hi, Wonder if someone could help me, Im looking at joining two tables in Analytics to create a new table, Im not an expert on SQL?
I am wanting to use both of the historic data and current data tables to create a new table, with new values as shown in green - is this easy enough?
| Historic Data | Current Data | New Table |
| Paid Date | Paid On | Date Paid |
| Order Line Total | Grand Total | Total |
| Order Status | Payment Status | Overall |