Skip to Content
0
Former Member
Jul 22, 2005 at 02:02 AM

SELECT POOLED TABLE IN SUBQUERY

283 Views

Hi all,

how to select pooled table in subquery?

e.g. Pooled table: A017

SELECT * FROM A017

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE exists ( SELECT * FROM EINA WHERE MATNR = A017~MATNR ).

it gives a syntax error and runtime error when I use A017-MATNR.