Thanks in advance for this basic question. I could not find the answer thus the post.
Imagine I have 2 tables (in the same base).
Table 1 has 3 columns.
- col #1 has some key
- Col #2 is date
- col #3 has sale amount
There would be multiple sales on same date.
Table 2 has two column:
- Col #1 is the date
- Col #2 >>> I would like this to be the sum of all the sales in from Table 1.
How do I link the two tables to get the sales summary.