3 Replies Latest reply: Jun 26, 2013 11:26 AM by tokashio tokashio RSS

    Urgent : Doubt in Load statement

    Vishnu Sreekumar

      Hi All,


      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



      LOAD *


      WHERE student_id in

      (LOAD student_id

      RESIDENT B);



      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.



      Vishnu S