i need help in this query.
select fbuda vavtyp aubel breite_s HOEHE_S from zzjhtfp INNER JOIN jhamot ON zzjhtfpaubel = jhamotavm_nr INTO table BDATA WHERE zzjhtfp~kunnr = p_custid.
How can I change the query to get one more field(wrshb - field name) from table mhnd(table) which has the common field with zzjhtfp(view) as kunnr.
but mhnd is a cluster table so I cannot use join statements.
thanks in advance.