Skip to Content
Former Member
Jun 02, 2005 at 07:13 PM

help in the query


hi folks,

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.