Duda sobre una consulta

[ContraVeneno]

Código SQL [-]
select B.fecha, B.parte,
(select A.total 
from TuTabla A 
where B.fecha=A.Fecha 
and B.parte=A.Parte 
and A.dia='01') as dia1,
(select A.total 
from TuTabla A 
where B.fecha=A.Fecha 
and B.parte=A.Parte 
and A.dia='02') as dia2,
(select A.total 
from TuTabla A 
where B.fecha=A.Fecha 
and B.parte=A.Parte 
and A.dia='03') as dia3
from TuTabla B
Group By B.Fecha, B.Parte