Number matching with SQL

[creeping]

This is more relating to SQL statements in Access but its use is in a VB app.

If I had 2 tables each with similar data i.e

ID Num
1 1.2
2 2.5
3 0.9
4 6.7
5 8.5

is it possible to match the numbers values to the other corresponsing number values in the other table with the match criteria that the number must be within 1 but be the nearest.

Cheers

 

[crosmill]

yes,

Do you want it in SQL or VB