Decimal place in join function

[Pettor]

Hello guys,

I would like some help with the below code.
I am trying to build a query that will populate some data after combining two tables.
I have everything in place except the bold part of the join where I would like to count the value of the field2 +0.2.
For some strange reason when I don't add a decimal place it works as it should but using a dot it breaks the query.
Any thoughts?

FROM Table1 LEFT JOIN Table2 ON Table1.Field1 = Table2.Field1 AND Table1.Field2 = Table2.Field2+0.2

Thanks

 

[Joe4]

You don't do calculations in the "ON" clause. Those are only for perfect matches. But you should be able to do it in the WHERE clause, i.e.

FROM Table1 LEFT JOIN Table2 ON Table1.Field1 = Table2.Field1 
WHERE Table1.Field2 = Table2.Field2+0.2

 

[Pettor]

Great, Thanks!

 

[Joe4]

You are welcome.
Glad I was able to help!