Using Criteria for nested queries

[Jesal Doshi <je...@jalvamedia.com>]

Hi

Turbine newbie:

I would like to know how can criteria be used with context of sub queries. I am trying to create the following sql:

select * from employees where empid in ( select empid from companyemp where companyid = "value");
here employees, companyemp are table names.

How do the above query being constructed using Criteria so as to get the result in a single database call.

Any insights, ( sample syntax ) in the above would be highly appreciated.

Regards

Jesal Doshi