topic Re: Inner Join Problem in Application Development and Automation Discussions

Inner Join Problem

Former Member — Thu, 05 Jun 2008 07:15:01 GMT

Can anyone help me out?

I have a select query as below using inner join.

When all ranges are empty, it works fine.

When RA_SELOPT_GBDAT is filled, it works fine.

However if any other range is filled individually, select query fails.

=======================

SELECT T1~PERNR

T1~NACHN

T1~VORNA

T1~MIDNM

T1~GBDAT

T2~USRID

FROM PA0002 AS T1 INNER JOIN PA0105 AS T2

ON T1_{PERNR = T2}PERNR

INTO TABLE IT_PA0002

WHERE

T1~NCHMC IN RA_SELOPT_NCHMC

AND T1~VNAMC IN RA_SELOPT_VNAMC

AND T1~MIDNM IN RA_SELOPT_MIDNM

AND T1~GBDAT IN RA_SELOPT_GBDAT

AND T2~USRTY IN RA_SELOPT_USRID.

=======================

Please let me know. Would reward for useful answer.

thanks

Re: Inner Join Problem

Sm1tje — Thu, 05 Jun 2008 07:23:50 GMT

Probably the only thing which can cause this is the fact that for that particular value in your select options, there really are NO values in that particular table. So first make sure that values are available by checking this table in SE16.

Re: Inner Join Problem

Former Member — Thu, 05 Jun 2008 07:25:36 GMT

hi,

you have use 'AND' in where condition . So to get values all ur conditon must meet.