topic Re: select querry in Application Development and Automation Discussions

select querry

Former Member — Wed, 18 Mar 2009 12:30:05 GMT

hi experts.

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_sym FROM ismp

JOIN ismitop ON ( ismp_{ismnr = ismitop}ismnr )

JOIN ismitpr ON ( ismp_{ismnr = ismitpr}ismnr )

WHERE ismp~ismnr IN s_sympt.

i am using this select querry but when the ismnr is not mensioned in any of ismitop or ismitpr but is ther e in ismp. the table it_sym is null.

i want full join. how should i write.

plz suggest the code.

with regards

ajay

Re: select querry

Former Member — Wed, 18 Mar 2009 12:32:16 GMT

Try using left join instead of join.

Re: select querry

Former Member — Wed, 18 Mar 2009 12:34:02 GMT

Remove INTO CORRESPONDING FIELDS OF it hampers the performance of the table.

Split the select query into two select queries .

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_sym FROM ismp

LEFT OUTER JOIN ismitop ON ( ismp_{ismnr = ismitop}ismnr )

WHERE ismp~ismnr IN s_sympt.

OR:

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_sym FROM ismp

JOIN ismitop ON ( ismp_{ismnr = ismitop}ismnr )

WHERE ismp~ismnr IN s_sympt.

THEN

Use:For All entries in IT_SYM For last join JOIN ismitpr ON ( ismp_{ismnr = ismitpr}ismnr )

Regards,

Gurpreet

Re: select querry

Former Member — Wed, 18 Mar 2009 12:34:03 GMT

hello,

use LEFT OUTER JOIN

With regards

Ajantha R

Re: select querry

Former Member — Wed, 18 Mar 2009 12:35:00 GMT

but when i used the left join the internal table doesnot have ismnr field value. why it is so ?

Re: select querry

Former Member — Wed, 18 Mar 2009 12:36:47 GMT

Because left join brings the join only when it exists, but preserves the left part even if the right part is absent.

Re: select querry

Former Member — Wed, 18 Mar 2009 12:39:51 GMT

For All entries in IT_SYM For last join JOIN ismitpr ON ( ismp_{ismnr = ismitpr}ismnr )

creating syntex error.

Re: select querry

Former Member — Wed, 18 Mar 2009 12:40:28 GMT

specify the table name against the fieldsto be picked from

Eg: select ismp~ismnr

ismp~< >

from ........

Re: select querry

Former Member — Wed, 18 Mar 2009 12:51:34 GMT

hi gurpreet

has u told me to write this one.

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_sym FROM ismp

LEFT OUTER JOIN ismitop ON ( ismp_{ismnr = ismitop}ismnr )

WHERE ismp~ismnr IN s_sympt.

use: For All entries in IT_SYM For last join JOIN ismitpr ON ( ismp_{ismnr = ismitpr}ismnr ).

use is not a valid key word.. it is saying like that.

plz help me.

ajay

Re: select querry

Former Member — Wed, 18 Mar 2009 13:49:37 GMT

select ismp~ismnr

ismp~ismtp

ismp~ismart

ismp~objnr

ismp~valdtfrm

ismp~valdtto

ismitop~opgrp

ismitop~opcod

ismitpr~prgrp

ismitpr~prcod

from ( ismp LEFT JOIN ismitop ON ( ismp_{ismnr = ismitop}ismnr )

LEFT JOIN ismitpr ON ( ismp_{ismnr = ismitpr}ismnr ) )

into corresponding fields of table IT_SYM

WHERE ismp~ismnr IN s_sympt.

even after writing this the record has not been fetched if the data is not mainsioned in any table of corresponding ismnr.

please help..

ajay