HQL Query:
from Customer as customer where customer.username like '%"+customer+"%' and " +
" customer.statusMap="+StatusMapInterface.ACTIVE+" and " +
" customer.customerId in (select distinct cRole.customer from CustomerRole as cRole where cRole.role!="+RoleMap.SITEADMIN+")" +
" order by registeredDate asc

I need Criterian query. Please help me..
In the above Cusomer is the Parent class.
Cusomer_Rile is the child class.
customer_id in Customer class is having FK relation with Customer_Role table customer_id column.

Please let me know how to Query using create criterain api.
I already spent more than 10 hours for this.
Please help me ...

Thanks in Advance