joining price layer to order_seat_hist?

Hi all,

I'm in the process of Frankensteining some reports together (we have some staff who love "this part of this report and this other part of that report, and want it all together on one page" , and I'm wondering if anyone knows of a roundabout way to join price layer to order_seat_hist?  The specific piece I'm having a mental block on is daily count and daily amount, broken by price type category, but only for one particular price layer.  

Thanks!
Kathleen