topic Re: Error in inner join in Application Development and Automation Discussions

Error in inner join

Former Member — Mon, 16 Feb 2009 07:08:01 GMT

Hi i wrote the following querry but getting error


Comma without preceding colon (after SELECT ?).

the queerry is like this


 SELECT ekko~lifnr
         lfa1~adrnr
         adr6~smtp_addr
         into ( l_lifnr, l_adrnr, l_smtp_addr )
         from ( ( ekko inner join lfa1 as lfa1 on ekko1~lifnr = lfa1~lifnr )
                       inner join adr6 as adr6 on lfa1~adrnr = adr6~adrnr ).
 
  ENDSELECT.

Re: Error in inner join

Former Member — Mon, 16 Feb 2009 07:09:40 GMT

u dont want any " , " for between l_lifnr, l_adrnr, l_smtp_addr .....

Re: Error in inner join

Former Member — Mon, 16 Feb 2009 07:11:03 GMT

Hi ,

Try the same code removing coma -

SELECT ekko~lifnr
         lfa1~adrnr
         adr6~smtp_addr
         into ( l_lifnr  l_adrnr _smtp_addr )                              " Coma removed
         from ( ( ekko inner join lfa1 as lfa1 on ekko1~lifnr = lfa1~lifnr )
                       inner join adr6 as adr6 on lfa1~adrnr = adr6~adrnr ).
 
  ENDSELECT.

Thanks and regards

Pinaki

Re: Error in inner join

Former Member — Mon, 16 Feb 2009 07:16:33 GMT

Hi,

try like this:

make a structure taking the reqd fiedls from the mentioned tables and then make a internal table e.g it_a

SELECT ekko~lifnr

lfa1~adrnr

adr6~smtp_addr

into corresponding fields of table it_a

from ( ( ekko inner join lfa1 as lfa1 on ekko1_{lifnr = lfa1}lifnr )

inner join adr6 as adr6 on lfa1_{adrnr = adr6}adrnr ).

ENDSELECT.

Regards

Rajesh Kumar

Re: Error in inner join

Former Member — Mon, 16 Feb 2009 07:17:32 GMT

try this:

SELECT 
         ekko~lifnr
         lfa1~adrnr
         adr6~smtp_addr
 into ( l_lifnr, l_adrnr, l_smtp_addr )
 from ekko as ekko inner join lfa1 as lfa1 on ekko~lifnr = lfa1~lifnr
 inner join adr6 as adr6 on lfa1~adrnr = adr6~adrnr.
 ENDSELECT.

regards,

Mon Magallanes

Re: Error in inner join

Former Member — Mon, 16 Feb 2009 07:20:31 GMT

Hi,

Instead of like this

SELECT ekko~lifnr

lfa1~adrnr

adr6~smtp_addr

into ( l_lifnr, l_adrnr, l_smtp_addr )

remove commas and write like this

into ( l_lifnr l_adrnr l_smtp_addr ).

Regards,

Jyothi CH.

Re: Error in inner join

Former Member — Mon, 16 Feb 2009 07:28:38 GMT

Hi use the Following Code .

SELECT EKKO~LIFNR

LFA1~ADRNR

ADR6~SMTP_ADDR

INTO (L_LIFNR ,L_ADRNR ,L_SMTP_ADDR )

FROM ( EKKO INNER JOIN LFA1 AS LFA1 ON EKKO_{LIFNR = LFA1}LIFNR )

INNER JOIN ADR6 AS ADR6 ON LFA1_{ADRNR = ADR6}ADDRNUMBER .

The Prob with your code was that u shd not use any space after into( l_lifnr....)

it shd be like INTO(L_LIFNR.....)

Hope this resolves your problem.

Re: Error in inner join

Former Member — Mon, 16 Feb 2009 07:28:59 GMT

Hi Oorvi,

This is tested its working fine... you can use this...

data :
 l_lifnr type ekko-lifnr,
 l_adrnr type lfa1-adrnr,
 l_smtp_addr type adr6-smtp_addr.
 
SELECT ekko~lifnr
         lfa1~adrnr
         adr6~smtp_addr
         into (l_lifnr,l_adrnr,l_smtp_addr)
         from ( ( ekko inner join lfa1 as lfa1 on ekko~lifnr = lfa1~lifnr )
                       inner join adr6 as adr6 on lfa1~adrnr = adr6~smtp_addr ).
 
  ENDSELECT.

Regards,

Siddarth