Hi, I would like to execute a query like this :select * from table_a where id in (select id from table_b). What is the right syntax to use ?
I tried first without the subselect :
myselect.from(MY_TABLE).where("id","in","("+StringUtils.join(idList,",")+")")
but this generates a query like
SELECT * FROM mytable WHERE id in '(10,10)
You notice the ' ?Can someone help ? Thanks Henk _______________________________________________ Rife-users mailing list [email protected] http://lists.uwyn.com/mailman/listinfo/rife-users
