SELECT with EXISTS

Former Member — Thu, 19 Apr 2007 09:03:43 GMT

hi all!

have a question about SELECT statement.

I would like to make an SELECTION

eg.

SELECT SINGLE SUM( menge )

FROM eban

INTO (cmenge)

WHERE matnr = bestand-matnr

AND werks = bestand-werks

AND afnam = bestand-lgort

AND bsart = 'ZN'

AND loekz EQ ''

AND statu = 'N'

OR statu = 'B' -> <b>HERE I WOULD LIKE TO CHECK IF RECORD EXISTS IN

OTHER TABLE IF STATU = 'B'</b>

<b>SOMETHING LIKE THIS:</b>

WHERE EXISTS (SELECT

FROM ekpo AS ekpo

INNER JOIN eban AS eban

ON ekpo_{ebeln = eban}ebeln

WHERE ekpo~statu = 'B'

AND ekpo_{banfn = eban}banfn

AND ekpo_{bnfpo = eban}bnfpo

AND ekpo~loeks = 'L'.)

But my way ain't right... so..am asking u for some further instructions and thank you in advance!

Maja

Message was edited by:

Maja Zugaj

Re: SELECT with EXISTS

Former Member — Thu, 19 Apr 2007 09:08:43 GMT

Write the Inner join for the select ...

Regards

Sudheer