Sometime a value of 1 could be interpreted as 1.000001 or 0.999999 in DOUBLE.
I would suggest you to create a new field (STRING), and migrate the values of the desired field to it using Field Calculator.
Use the STRING fields to join tables.
Think Location