SubQueries questions

Question

From one table MWOHED, I need to retreive 2 outputs (VHITNO and VHORQT). One of these outputs VHITNO (=035172) is then needed to retrieve another information from another table MITMAS. How can I combine those 2 queries to retrieve all the information (VHITNO, VHORQT and MMITDS)?

The first query is as such:


The second query is as such:



thanks.