4 Replies Latest reply: Jul 21, 2014 4:34 AM by Crystal Li RSS

    Sql's in clause can have Resident Load

    Michael Jordan

      Hi all,

       

      I have a resident table, in which I have a list of values.

       

      I need to use those values in the IN clause of SQL. like

      SQL Select * from Table1 where Value1 IN ( Load Value2 Resident Master1);

       

      please suggest.

       

      I have some values coming from some different source which I need to use while loading another table.

      Thanks in advance.