|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
JOIN on FIXED
From: Fabio Pinotti (fabio.pinotti
icteam.it)
Date: Tue Feb 22 2005 - 09:10:54 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, I've encountered a strange behaviour with join on columns of different data type.
I had a Fixed(9,0) column in table A and a Fixed(6,0) column in table B, with the same numerical value. But the join between the tables returned no result.
Only upgrading the fixed(6,0) column in table B to data type fixed(9,0), solved the problem.
Is this a known bug?
Best regards
Fabio
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]