SQL Question - Update

I ended up trying every kind of join I could muster without any help. The table with the sales data is just too damn big and/or my SQL sucks. I am ok with the later.

After trying for quite some time, and talking with the other developer we found that the previous year had addressed this particular problem by NOT doing it. They instead had made their reporting code much larger and messier than the other reports by breaking the data queries in parts and massaging the data back together in the Java code. Unfortunately it looks like this is what I will have to do too. Instead of extending the base reporting classes, adding the new SQL statement and being done with it, I will have to write a whole bunch of code to aggregate the data and put it in the format that the reports JSPs want it in. Nothing horrible, but not the clear and simple solution I was hoping for.

Thanks for the suggestions.