Hi To me it looks like quantity is being multiplied by the price and then added to total.
Try something like this SELECT total,(quantity*price) as QP from sales where total !=QP AND salesid=122 On 2012-12-29, at 7:25 AM, Trimurthy wrote: > hi, > i am working with mysql 5.1.36 and i wrote the following query. > > select total,quantity*price from sales where total != quantity*price and > salesid=122; > > OUT PUT: > > total quatity*price > 330.46 330.46 > > here quantity is 15.5 and price is 21.32 > > both the values and data types are double(total,quantity and price). can > anyone tell me why this is happening. > > Normal 0 false false false EN-US > X-NONE AR-SA > > > > > > > Thanks & Kind Regards, > TRIMURTHY > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql