I have two tables. Table 1 has collection data such as weight, date collected. Table 2 has dispatch data such as dispatch weight and dispatch date.
I want put both into a table but there is no link in the data between the two tables such that you get
Month Weight collected Weight Dispatched
Jan 10 15
Feb 12 24
U can link them by date?
Or, use canonical dates
please refer tio this: