6 Replies Latest reply: Mar 7, 2014 7:58 AM by Manish Kachhia RSS

    select where id in list

      Hi,

       

      I've a select statement of the following syntax:

       

      Table:

      load *

       

      from table.qvd

      where id = 1 or 2 or 3;

       

      Because the list of applicable IDs is considerably long I'd like to simplify the statement to something like

       

      Table:

      load *

      from table.qvd

      where id in IDlist;

       

      Any ideas on how to achieve this?!