Just a small suggestion if this is your sort of thing. I usually just
do it all in one bit without the individual method calls on the local
vars:
Select select = new Select(yourdatasource)
.from("MYTABLE")
.field("field1")
.where("id", "in", new Select(yourDatasource)
.from("table_b")
.field("id"));
On 03 Aug 2006, at 22:09, mustafa sener wrote:
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
--
Geert Bevin
Uwyn "Use what you need" - http://uwyn.com
RIFE Java application framework - http://rifers.org
Music and words - http://gbevin.com
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
