in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month as 0 for all columns.?
BUT there is no entry for the month suppose mar or april.then there will be no record for mar or aprilthere is no columns for those months becuse i have not entered any thing for those months.i only entered for sales/purchase
[Br _extended="true" />[Br _extended="true" />plz suggest how i will write.