If I understand you correctly, I should create a REMOTE view like
SELECT * from B where b.key=?cKeyvalue


Then I would do a SCAN of the local table like:

SELECT A
SCAN
cKeyvalue=A.key
SELECT * from remoteview
append results to a result cursor
ENDSCAN

Is that the idea ?