How can I possibly preserve entries from two tables??
Example Structure: Month, Material, Ordered Quantity
Table A (e.g. from Branch 1)
January, Cotton, 10
April, Wood, 5
November, Steel, 12
Table B (e.g. from Branch 2)
February, Plastic, 4
April, Wood, 6
December, Steel, 10
Desired Output:
January, Cotton, 10
February, Plastic, 4
April, Wood, 11
November, Steel, 12
December, Steel, 10
-> I cannot use either LEFT JOIN, nor RIGHT JOIN, nor INNER JOIN, though this is a case that is soooo common and I can't find a way to do it??