From: Trimurthy
Date: December 29 2012 12:25pm
Subject: Query Resulting error
List-Archive: http://lists.mysql.com/mysql/228853
Message-Id: <43a3c37a$358bbcbc$244f0251$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0001_671A1342.684FFBCE"

------=_NextPart_000_0001_671A1342.684FFBCE
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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
  

------=_NextPart_000_0001_671A1342.684FFBCE--