SELECT C.fieldX, C.fieldY FROM A, B, C
WHERE A.this = 'value of interest'
AND A.bkey = B.key
AND B.ckey = C.key