Skip to Content
author's profile photo Former Member
Former Member

Inner Join Problem

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 T1PERNR = T2PERNR

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jun 05, 2008 at 07:23 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2008 at 07:25 AM

    hi,

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.