Hi,
how can I connect these Select-Statements?
Is it possible with a subquery or a join?

SELECT SUM(vmdtsv.mncompricf)
FROM VMDTSV Inner join vmdh ON VMDH.nmdocid=vmdtsv.nmdocid
WHERE vmdh.txtype = 'C04026'


SELECT vmdh.txtype, vmdh.txdesc,vmdh.nmblabrdur, vmdbhd.nmblabrdur,
SUM(vmdh.mnblabrcst+vmdh.mnbsubccst+vmdh.mnbitemcs t+vmdh.mnbservcst+vmdh.mnboverhd)
AS COactual,
SUM(vmdbhd.mnblabrcst+vmdbhd.mnbsubccst+vmdbhd.mnb itemcst+vmdbhd.mnbservcst+vmdbhd.mnboverhd)
AS CObudget,
SUM(vmdbhd.mnblabramt+vmdbhd.mnbsubcamt+vmdbhd.mnb itemamt+vmdbhd.mnbservamt)*vmdh.nmcurrrate
AS INbudget
FROM VMDBHD
Inner JOIN VMDH ON VMDBHD.nmdocid=VMDH.nmdocid

WHERE vmdh.txtype = 'C04026'
GROUP BY vmdh.txtype, vmdh.txdesc, vmdh.nmblabrdur, vmdbhd.nmblabrdur,
vmdh.nmcurrrate