I have to retrieve some data from tables with structure like:
Table 1
Id C(2) - key field
Name C(20)

Table 2
Id C(2) - foreign key
SomeData C(20)

Fields Id contain binary data and tables are marked with code page 866. I open this tables in VFP 2.5 with current codepage 1251.
Now I can find records in table 2 corresponding to any record in table 1 only if I perfom SET NOCPTRANS TO Id. But this statement cannot help me when I try to do, for example:

SELECT SomeData FROM Table1, Table2 WHERE Table1.Id = Table2.Id AND Table1.Name = "A"

(searched record has Id = CHR(18)+CHR(186))
I think VFP opens again tables participating in SELECT so perfomed SET NOCPTRANS has no effect.

How to do this task?