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.

Iftikar Hussain · Answer

Hi Try like this SELECT A.VHITNOA.VHORQTB.Mmitds FROM pfods.MWOHED A INNER JOIN MITMAS B ON B.Mmitno=A.VHITNO WHERE A.VHMFNO='5749704' Regards Iftikar

TAN WhoAMI · Answer

SELECT A.VHITNOA.VHORQTB.Mmitds FROM pfods.MWOHED A INNER JOIN pfods.MITMAS B ON B.Mmitno=A.VHITNO WHERE A.VHMFNO='5749704'

Sanjeeb Lenka · Answer

Is there any relation between the two table or any common column . if not then you can use this SELECT V.VHITNOV.VHORQTM.MMITDS AS DESCRIPTION FROM pfods.MWOHED V CROSS JOIN pfods.MITMAS M WHERE V.VHMFNO='6749704' AND M.MMITNO='0351724'