BusinessObjects Board

subselect

building reports webintelligence legacy 1/2
#1

i need to create a sub query dependent on two object

ie

SELECT user_id, Name from 
                C, D
      where x=y
       and m=r

i know how to do a sub select for one object

ie

select user_id From
            C
     where x=y
      and   m=r

but how to i create a subselect for two i tems

the way i usually do a subselect is choosing the subselect and then
choose the object use the "in list " then object again

  1. should i use two subselects with an AND statement or OR statement

  2. should i do this at the universe level ( i dont really want to do this)

  3. try a union since the main query is looking for all user_id that match the subselect. I am not too good at thinking about the union.
    if a union statement i guess it would be an intersect . right ???
    [/code]

honkeyhindu (BOB member since 2007-03-29)