Nested Select Statement or Nested Select Elements

[kiran vuppla]

Hi,
    I am new to IBatis and am in learning curve stage. I would like to know how 
to write a nested select statement in the IBatis SqlMapConfig file.
   
    My nested Oracle Select Statement:
   
    select * 
  from table1
   where val1 in (
               select val2 from           /* Self Join */
                      table2 a, table2 b
                      where a.id = b.id
                      and a.val = b.val
                     and b.id = id
                    and a.id != id;
                )
   
  I would like to know how to write a nested <select> element in IBatis in the 
config file.
   
  Thanks,
KV

       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.