3 Replies Latest reply: Mar 27, 2013 1:01 PM by 998980 RSS

    SQL query as a filter in OBIEE

    999127
      i have a list of student_ID in one table ( lets say A) and its subset in another table( table B)
      i want a filter such that only the student_ID in table A which are not in table B are selected.

      i am selecting operator "not equal to/ is not in" of the student_id in table A and choosing SQL query option for adding the value.

      select distinct student_id from DatabaseName.B

      Its not working. Its giving error after a lot of minor tweaks.

      Can you help how to resolve this