Present a sql query in service engine ofbiz

[AlexLe]

I would like to present a sql query in service engine ofbiz as follows:

select * from A where A.a in (select B.a from B where B.b = '2');

please help me. thanks so much