hi,

actually i wanted to know that while writing views what appraoch i take ,

like using of flat tables, using left joins for non-mandedory fields aur what??

there is no...