ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kiran vuppla <kirankumar_vup...@yahoo.com>
Subject Nested Select Statement or Nested Select Elements
Date Sun, 10 Feb 2008 22:19:09 GMT

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.
Mime
View raw message