select A.A, B.B from B join A on B.C = A.A; でいいのけ?