I was hoping someone could help me with an example of how to merge 2 tables with a sum for one column. for example, I have the following columns on table1(Ordered): ID,quantity, twoply, threeply, ponumber, date … and the following columns in table2(Shipped): ID, quantity, twoply, threeply, ponumber. … what i am trying to do is show a table with quantity ordered/shipped/remaining of twoply and quantity ordered/shipped/remaining of threeply. so i think i need to merge these tables somehow. I want one table row per ponumber. can anyone help? thanks in advance!
Take a look at this.
Excellent, that works. Thanks Andrew!