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