This content has been marked as final. Show 3 replies
I have two resident tables sa A and B both having student_id field as common.
I need to devise a load statement to create a table C such as
WHERE student_id in
just like we use in select statements like -- select * from table A where student_id in (select student_id from table B)
I know that the above code is wrong and ofcourse it is not working.
Please help me to find a solution for my requirement.