select statement in hibernate criteria

I want to make the below query in hibernate criteria

SELECT * FROM ORDERS O, PRODUCT P WHERE O.ORDER_ID=P.ORDER_ID and order.orderName='xyz';

thanks for your help

Please try below:

List orders = sess.createCriteria(Order.class)
    .createCriteria("products", "product")
        .add( Restrictions.eq("orderName", "xyz") )
    .setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP)
    .list();

Hope that helps.