inner join where condition?

[Former Member]

hi all this i wrote inner join but i want for particular purchase order

what shall i add in where condtion

 SELECT SINGLE
         a~ernam
         b~persnumber
         b~addrnumber
         c~smtp_addr
         INTO (l_ernam, l_persnumber,l_addrnumber,l_smtp_addr)
         FROM ( ( usr21 AS b INNER JOIN ekko AS a ON b~bname = a~ernam )
         INNER JOIN adr6 AS c ON b~addrnumber = c~addrnumber
                           AND b~persnumber = c~persnumber ).

[Former Member]

hi all this i wrote inner join but i want for particular purchase order

what shall i add in where condtion

 SELECT SINGLE
         a~ernam
         b~persnumber
         b~addrnumber
         c~smtp_addr
         INTO (l_ernam, l_persnumber,l_addrnumber,l_smtp_addr)
         FROM ( ( usr21 AS b INNER JOIN ekko AS a ON b~bname = a~ernam )
         INNER JOIN adr6 AS c ON b~addrnumber = c~addrnumber
                           AND b~persnumber = c~persnumber ).

[viquar_iqbal]

SELECT SINGLE

a~ernam

b~persnumber

b~addrnumber

c~smtp_addr

INTO (l_ernam, l_persnumber,l_addrnumber,l_smtp_addr)

FROM ( ( usr21 AS b INNER JOIN ekko AS a ON b_{bname = a}ernam )

INNER JOIN adr6 AS c ON b_{addrnumber = c}addrnumber

AND b_{persnumber = c}persnumber ) where PO eq '112'.

you dont need to select the field purchase order for this .

[Former Member]

Hi Oorvi

SELECT SINGLE
         a~ernam
         b~persnumber
         b~addrnumber
         c~smtp_addr
         INTO (l_ernam, l_persnumber,l_addrnumber,l_smtp_addr)
         FROM ( ( usr21 AS b INNER JOIN ekko AS a ON b~bname = a~ernam )
         INNER JOIN adr6 AS c ON b~addrnumber = c~addrnumber
                           AND b~persnumber = c~persnumber )
      WHERE a~ebeln EQ lc_ebeln.

Pushpraj

[former_member585060]

SELECT SINGLE
         a~ernam
         b~persnumber
         b~addrnumber
         c~smtp_addr
         INTO (l_ernam, l_persnumber,l_addrnumber,l_smtp_addr)
         FROM ( ( usr21 AS b INNER JOIN ekko AS a ON b~bname = a~ernam )
         INNER JOIN adr6 AS c ON b~addrnumber = c~addrnumber
                           AND b~persnumber = c~persnumber )
         WHERE a~ebeln = p_ebeln.                                     " p_ebeln may be a Parameter or any value of PO

[Former Member]

SELECT SINGLE
         a~ernam
         b~persnumber
         b~addrnumber
         c~smtp_addr
         INTO (l_ernam, l_persnumber,l_addrnumber,l_smtp_addr)
         FROM ( ( usr21 AS b INNER JOIN ekko AS a ON b~bname = a~ernam )
         INNER JOIN adr6 AS c ON b~addrnumber = c~addrnumber
                           AND b~persnumber = c~persnumber )
         where a~orderfieldname = '3111'." Just add this but i dnt know in which table is order no field is present

[Former Member]

Hi,

use

WHERE a~ordno = p_ordno.

here qrdno is the field the has the ord no and P_ordno is the selection from screen i.r through parameter.

hope this will sole ur problem.

Suraj

[former_member222860]

Hi,

Put

and a~ebeln = p_ebeln.   "p_ebeln is a parameter in sel. screen

in your where_clause.

And if u got the answer Pl. Close all of your previous threads.

thanks\

Mahesh

Edited by: Mahesh Reddy on Feb 16, 2009 2:38 PM

[Former Member]

i don't have any selection screen parameter or select-options.

[Former Member]

where a~orderfieldname = '3111'." Just add this but i dnt know in which table is order no field is present

3111 can be changed according to ur required order no

[Former Member]

hi,

Then on what basis r u going to decide which particular order u want.

[Former Member]

Hi Oorvi,

just do as following.

SELECT SINGLE
         a~ernam
         b~persnumber
         b~addrnumber
         c~smtp_addr
         INTO (l_ernam, l_persnumber,l_addrnumber,l_smtp_addr)
         FROM ( ( usr21 AS b 
        INNER JOIN ekko AS a ON a~bname = b~ernam ) 
        INNER JOIN adr6 AS c ON c~addrnumber = b~addrnumber
                                        AND c~persnumber = b~persnumber )

         *WHERE a~ebeln = p_ebeln*.                     "p_ebeln is your selection screen parameter