The first query is as such:

The second query is as such:

thanks.


Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Iftikar HussainPosted Jul 30, 2013, 12:20 AM
Try like this
Regards,
Iftikar
TAN WhoAMIPosted Jul 30, 2013, 1:13 AM
Sanjeeb LenkaPosted Jul 30, 2013, 12:30 AM
SELECT V.VHITNO,V.VHORQT,M.MMITDS AS DESCRIPTION FROM pfods.MWOHED V
CROSS JOIN
pfods.MITMAS M
WHERE V.VHMFNO='6749704'
AND
M.MMITNO='0351724'