float problem...

| +-+ 1 row in set (0.00 sec) If i try to attach this data to Mysql 4.1.14-standard. It is truncating the value to . Is there any way to solve this issue without chaning the db structure... ? Regards, Senthil

pls. help me?

hi pls. help me , how to update 2 tables like this sql update table1 set table1.fld2 = table1.fld2 where table1.fld1 = table2.fld1 senthil.r _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com