JOINing two tables in an INSERT INTO

Is it actually a REAL? That's almost certainly not what you want. Just because a reason code happens to be something like digits.digits, doesn't mean you should represent it with REAL. If you do, then how do you distinguish between 123.1 and 123.10 and 123.100?

2 Likes