hello all,
while running a query in mySQL i am getting unexpected results. some
time it display results and sometime blank screen. i dont know whether its a
mysql bug or not. kindly, let me know how to deal with it. myquery is:
SELECT code,unit,sum(issued),sum(consumed),sum(diff),truncate((sum(issued) -
sum(consumed))/sum(issued)*100,2) percent_diff
FROM vw_daily_material_issue_consume
WHERE date BETWEEN '2007-03-01' AND '2007-03-08' GROUP BY 1,2;
any help in this regard will be a great favor.
Thanx
Regards,
usman
---------------------------------
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
[Non-text portions of this message have been removed]
