5 Replies Latest reply on Jan 13, 2010 7:28 AM by -==cfSearching==-

    QoQ Help!!!

    emmim44 Level 1

      Query Of Queries syntax error.
      Encountered "event_number in ( select. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,

       

      Output SQL

      select * from SearchRes0 where event_number in ( select distinct p.event_number from ops$new.ne_node n , ops$new.ne_problem p , ops$new.ne_lob l where 1 = 1 and p.event_number = n.event_number and p.event_number = l.event_number And p.problem_code in (30,40) )