SELECT X.a, X.b, X.c, Y.q, Y.a
FROM TabelaX AS X JOIN TabelaY AS Y
ON X.fk1 == Y.fk2;