Hi,
You can do it by using
where(String field, String operator, Select query) method of Select .
For your case:
Select selectInner = new Select(yourDatasource);
selectInner.from("table_b");
selectInner.field("id");
Select select = new Select(yourdatasource);
select.from("MYTABLE");
select.field("field1");
select.where("id", "in", selectInner);
will be the right syntax. If you refer to javadoc
you can find more detailed information on RIFE queries.
I hope this helps...
Mustafa
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.
_______________________________________________ Rife-users mailing list [email protected] http://lists.uwyn.com/mailman/listinfo/rife-users
