If you want to make selections (i.e. clicking in list boxes in the UI) on the fields in table02 and table03, then you need to load these tables. But then I don't understand your question: Your SQL statement doesn't load these fields.
However, if you just want to set filters during the load sequence, you can do this just by adding conditions to the where clauses in my script.
I would just load the three tables without any filters, making sure that the keys are OK:
C_PDS & '|' & V_ANNO as Key,
C_PDS as PDS,
RecNo() as Table01_ID
From table01 ;
RecNo() as Table02_ID
From table02 ;
C_PDR & '|' & V_ANNO as Key,
RecNo() as Table03_ID
From table03 ;
I assume that the keys are PDS and V_ANNO.
Then you can take care of filtering in the UI.
Ok, I will load all the table with the correct keys PDS and C_PDR.
Then, how do I write the sum of VOLUME as expression in a pivot?
table01.C_CARRIER = @Carrier
AND table01.V_ANNO = year(@StartDate)
AND table01.C_PDS IN
table02.DT_INI <= @StartDate
AND table02.DT_FINE >= @EndDate
AND table02.COD_TRASP = @Carrier
group by table01.C_PDS