select querry

[Former Member]

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

[Former Member]

Try using left join instead of join.

[Former Member]

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

[Former Member]

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

[Former Member]

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

creating syntex error.

[Former Member]

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

[Former Member]

hello,

use LEFT OUTER JOIN

With regards

Ajantha R

[Former Member]

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

[Former Member]

specify the table name against the fieldsto be picked from

Eg: select ismp~ismnr

ismp~< >

ismp~< >

from ........

[Former Member]

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