>If there are no child records in C all the fields are show NULL.
>If I use this view in report all the total fields fail asn .NULL. any thing is .NULL.
>
>Rajesh
Try NVL() e.g.
SELECT a.field, NVL(b.character_field,""), NVL(b.numeric_field,0) ;
FROM a LEFT JOIN b ON a.id = b.id...
Insanity: Doing the same thing over and over and expecting different results.