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:
![](https://test2.c-sharpcorner.com/forums/uploadfile/tanthiamhuat/07302013000332am/Query1.jpg)
The second query is as such:
![](https://test2.c-sharpcorner.com/forums/uploadfile/tanthiamhuat/07302013000332am/Query2.jpg)
thanks.