>>Sergey-
>>
>>>The INT() function accepts a numeric argument only.

... on TableA.Field1 = INT(VAL(TableB.Field2))

Also, it'll not be Rushmore optimizable if there's no index on INT(VAL(Field2)) in TableB.
>>
>>Since it's are remote view on SQL Server backend, that's pertinent, is it?
>
>No it's not. :)

Whew. You were just checking that I was awake, right? <g>