Skip to Content
0
Former Member
Jul 20, 2005 at 06:44 AM

SQL problem

19 Views

Hi all,

I'd like to use one sql to select MATNR from MARA and WERKS from MARC.

select MATNR MARC~WERKS

into corresponding fields of itab

from MARA

where exists ( select * from MARC where MATNR = MARA~MATNR ).

But I got a syntax error saying that wrong table name for MARC. How should I correct the SQL ?

Thanks.