Re: WHERE IN clause limitation

If you user a sub-select to specify the amout of possible cases, then try to replace your WHERE IN clause with:

  select WHAT_EVER
    from YOUR_DATA_TABLE
   WHERE identnr IN

         (select identnr
            from YOUR_JOIN_TABLE)

  Would be like that:

  select WHAT_EVER
    from YOUR_DATA_TABLE Data
   WHERE EXISTS

     (Select 'X'
        from YOUR_JOIN_TABLE Join
       where Data.identnr=Join.Identnr)

-- 
LR
DSE