Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tt ( h_no ) AS
SELECT 1 FROM DUAL;
1 rows affected

CREATE TABLE mth ( m_no ) AS
SELECT 1 FROM DUAL;
1 rows affected

CREATE TABLE mtk ( m_no ) AS
SELECT 1 FROM DUAL;
1 rows affected

select h_no, 
       ( select mth.m_no
         from   mth
                inner join mtk 
                on  (   MTH.M_NO=MTK.M_NO 
                    AND MTH.M_NO = tt.H_NO )
       ) maliyet
from   tt;


H_NO
MALIYET


1
1


select h_no, 
       ( select mth.m_no
         from   mth
                inner join mtk 
                on ( MTH.M_NO=MTK.M_NO )
         WHERE  MTH.M_NO = tt.H_NO
       ) maliyet
from   tt;


H_NO
MALIYET


1
1