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

       

      C:

      LOAD *

      RESIDENT A

      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.

       

      Regards,

      Vishnu S