vertical band

TigRon

How i must assign the masterData of vertical band and the masterData of plain band?

Count of columns(materials) and rows(Dates) is variable.
the select of vertical band:

select m.* 
from balance b
left join materials m on m.id = b.material_id

and the select of horizontal band:

select b.date,b.price,b.amount, ... ,m.id 
from balance b
left join materials m on m.id = b.material_id