Skip to Content
0
Former Member
Mar 18, 2009 at 12:30 PM

select querry

44 Views

hi experts.

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_sym FROM ismp

JOIN ismitop ON ( ismpismnr = ismitopismnr )

JOIN ismitpr ON ( ismpismnr = ismitprismnr )

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