SQL JOIN

Former Member — Mon, 13 Oct 2008 23:41:19 GMT

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

Re: SQL JOIN

Former Member — Tue, 14 Oct 2008 01:06:57 GMT

I solved the problem, it was a wrong data element used in the structure for the internal table.

Regards,

Christian

topic Re: SQL JOIN in Application Development and Automation Discussions

SQL JOIN

Re: SQL JOIN