i have fetched records with 3 tables joined i got 42 row of it it has a column name amount which is year wise so it contains 0 amount as well as some amount eg 20045,43550 etc
so i want to add a case or something so that i can get only amount which is greater then 0
i think i will have to write a case for that in query but im not sure of it so need help on the same
thanks
subin.
