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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!