[SQL] SUM not matching up on a JOIN

The trans table contains the stub for each transaction and the trans_item table contains all the items belonging to the transaction. I need to be able to pull categorized reports for items and have all of the totals less the discounts match up with the total from the stubs for a given period. Why

[SQL] FULL OUTER JOIN Question (mistake)

 20116 |    11216 |  20115 |   1 | 91400    |   0.50 |   0.0700 (1 row)   ^ that   Best, Tyler Kellen

[SQL] FULL OUTER JOIN Question

75 | 0.00  36437 |    20116 |    2.25 | 0.50 (2 rows)   ^ This should only return the second row.  What gives?   If anyone has the time to look at this I would greatly appreciate it!   Best, Tyler Kellen