Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL JOIN

Hi,

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.

Thanks,

Christian

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question