I have 2 tables (see below):
Whats the best way of joining them so I can have consolidated Customer ID list (1.0 + 2.0) but the records are not duplicated. so:
- if I do a total of points earned (so one address will only get counted once despite there are 2 separate customer ids)
- The Customer ID list will still list individually and show me the address and points earned accordingly. (i.e, I don’t want it to display as 2,5 | 234 street | 15 points earned . I would like to see 2 | 234 street | 15 points earned , 5 | 234 street | 15 points earned)
|Customer_ ID_2.0||Address||points earned|
Hope it make sense!