| http://www.w3.org/ns/prov#value | - Hi, I have 2 tables which has 2 float fields each.I am joining these two tables and comparing two float fields whether they are equal or not.Surprisingly, 2 fields with the same value returning not equal.SELECT *FROM Table1 t1 INNER JOIN @tab tmp ON t1.CustomerNo = tmp.CustNoWHERE cast(t1.TotalRevenue as float) <> tmp.CntRevTotalRevenue and CntRev has the same value 33679.8 but above query returns
|
