A quick question: Does the foramt of the numerical key variables matter in sql merge?

[Anna_Guo]

I am trying to merge two data base based on two key variables, both are numerical variables. I used sql to merge the two database and got zero observation. I don't know if it is because  they  have differnt format ( digits).  One shows F6., two show  Best12., and the last show nothing when I view the column format.

Any suggestion?

Thanks in advance.

[Anna_Guo · Accepted solution]

Never mind. It still not work after I changed format.

[Anna_Guo]

Thanks. I just figured out.