topic Re: Inner Join in Application Development and Automation Discussions

Inner Join

Former Member — Wed, 26 Jul 2006 10:17:55 GMT

Hi all,

I have problem in inner joins

My query is

select a_{vbeln b}vgbel from vbrp as a inner join lips as b on a_{vbeln = b}vgbel and ( a_{vgpos = b}posnr OR a_{vgpos = b}uecha)

The problem is we cannot use OR in inner joins

Please let me know any alternative

Thanks in advance

Regards

Neha Kapoor

Re: Inner Join

naimesh_patel — Wed, 26 Jul 2006 10:23:52 GMT

Hello,

Take all records as,

select a_{vbeln b}vgbel from vbrp as a inner join lips as b on a_{vbeln = b}vgbel

into internal table,

Then delete based on your _{vgpos = b}posnr OR a_{vgpos = b}uecha condition.

regards,

Naimesh

Re: Inner Join

Former Member — Wed, 26 Jul 2006 10:29:33 GMT

Hi,

You have to populate the values in the ranges table and pass the ranges table in the where condition with 'in' parameter,

Rgds,

Re: Inner Join

Former Member — Wed, 26 Jul 2006 10:30:47 GMT

Neha,

You can try following query..

select a_{vbeln b}vgbel

from vbrp as a

inner join lips as b

on a_{vbeln = b}vgbel

where a_{vgpos = b}posnr OR a_{vgpos = b}uecha..

Cheers,

Nilesh

Re: Inner Join

Former Member — Wed, 26 Jul 2006 10:33:50 GMT

hi Neha,

try this

select a~vbeln b~vgbel 
       from vbrp as a inner join 
            lips as b 
             on a~vbeln = b~vgbel and 
                a~vgpos = b~posnr OR 
                a~vgpos = b~uecha.

Re: Inner Join

Former Member — Wed, 26 Jul 2006 10:34:08 GMT

Hi Neha,

Use this code instead:

TABLES: VBRP, LIPS.

SELECT * FROM VBRP.

SELECT * FROM LIPS WHERE vbeln = VBRP-vgbel and

POSNR = VBRP-vgpos OR

UECHA = VBRP-vgpos.

ENDSELECT.

Regards