topic Re: inner join where condition? in Application Development and Automation Discussions

inner join where condition?

Former Member — Mon, 16 Feb 2009 13:23:20 GMT

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 ).

Re: inner join where condition?

viquar_iqbal — Mon, 16 Feb 2009 13:27:25 GMT

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 .

Re: inner join where condition?

Former Member — Mon, 16 Feb 2009 13:27:37 GMT

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

Re: inner join where condition?

former_member585060 — Mon, 16 Feb 2009 13:28:18 GMT

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

Re: inner join where condition?

Former Member — Mon, 16 Feb 2009 13:28:37 GMT

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

Re: inner join where condition?

Former Member — Mon, 16 Feb 2009 13:34:56 GMT

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

Re: inner join where condition?

former_member222860 — Mon, 16 Feb 2009 13:37:47 GMT

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

Re: inner join where condition?

Former Member — Mon, 16 Feb 2009 13:42:05 GMT

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

Re: inner join where condition?

Former Member — Mon, 16 Feb 2009 13:43:29 GMT

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

Re: inner join where condition?

Former Member — Mon, 16 Feb 2009 13:44:28 GMT

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

Re: inner join where condition?

Former Member — Mon, 16 Feb 2009 13:46:39 GMT

hi,

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