the following code throws the exception CX_SY_NO_HANDLER. Could it be that my Netweaver server does not support joins?
Or is there a semantic error in my code:
SELECT A~PRODUCT_ID A~PROD_INST_ID A~PRICE_CURRENT B~PRODUCT_NAME FROM GP1_PROD_INST AS A INNER JOIN GP1_PRODUCTS AS B ON A~PRODUCT_ID = B~PRODUCT_ID INTO CORRESPONDING FIELDS OF TABLE PRODUCT_DETAILS WHERE A~PRODUCT_ID = 1 .
If have the two tables GP1_PRODUCT ( attributes: PRODUCT_ID, PRODUCT_NAME )
and GP1_PROD_INST (attributes: PRODUCT_ID, ROD_INST_ID A~PRICE_CURRENT ).
and the internal table PRODUCT_DETAILS with all that fields and some other fields.