Matching data on a certain criteria ?

[TitanKing]

Hello everyone, I am looking at matching data with a certain criteria from two different tables. Lets asume this Table 1 has three values in 3 different fields:

Table 1: 30
27
80

Same with Table 2: 16
26
140

Now I would like to match values that has a less then or equal value of say a 5% margin, so 27 and 26 should match. I know it is possible but how.

I would appriciate any help, thank you, I know it is a privalige to get help from the community :bemused:

[konsu]

use an appropriate boolean expression where comparison expression is expected. e.g. ...WHERE (a/b>0.5)

[TitanKing]

Ok ill try, im not sure I understand but hell thanks for the clue... let me see if I can get it to work. Eish, this could get complicated !