Poti incerca 

SELECT DISTINCT Q.h  Q.x, Q.y, Q.z, Q.m, Q.n, Q.q

FROM

(
SELECT B.f, B.g, B.h, B.h  A.x, A.y, A.z, B.m, B.n, B.q
FROM (B INNER JOIN A ON B.w=A.w)
WHERE A.x = '1'
ORDER BY B.f, B.g, B.h

) AS Q 

DESI ... DESI ... DESI ...