Inner Join

[Former Member]

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

[Former Member]

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

[naimesh_patel]

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

[Former Member]

Hi,

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

Rgds,

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

ENDSELECT.

Regards