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:
Table 1
Customer_ID_1.0 | Address | points earned |
1 | 123 street | 20 |
2 | 234 street | 15 |
3 | 345 street | 30 |
4 | 456 street | 40 |
Table 2
Customer_ ID_2.0 | Address | points earned |
5 | 234 street | 15 |
6 | 123 street | 20 |
Hope it make sense!