Hopefully this is another simple SQL (2008) question!
I have two tables, table_1 and table_2. These tables have a column in common, product_code. Also there is a column called price_when_sold in both tables.
I would like to find product_code's from table 1 that are also in table 2, then sum the price_when sold in table 1 for that product_code, then also sum the price_when_sold in table 2 for that product_code. Then present them as columns in the same results.
Hopefully this is simple and quick for someone! :)