I need make this SQL question with Criteria.

SELECT a.id_
FROM
vsc_userversion AS a
JOIN vsc_usuario AS b
on a.idusuario = b.id_ and b.nombre = "xxx"




I try with this but doesn't work for me. How can i get a join in Criteria sintaxys?

criteria.createAlias("Usuario", "idusuario",JoinFragment.FULL_JOIN);
Criteria user = criteria.createCriteria("idusuario");
user.add(Restrictions.eq("nombre", this.params.get("nb")));
criteria = user;

Let me see if I can decipher your entity names

I'm sorry but thast doesn't work for me :(. I have two tables (Userversion and Usuario) And I want to make a Join between this tables. When i put your code the console dispatch this:

14:03:28,315 ERROR [STDERR] org.hibernate.QueryException: could not resolve property: Usario of: cl.vsoft.liferay.domain.Userversion

the primary key id_ in Usuario tables is the foreign key idusuario in Usuario

Do you know what is the problem?

PD: I'm sorry for my bad inglish

Could you post your classes, please?

//Userversion

public class Userversion implements java.io.Serializable,IDomainObject,IJson,ICombobox
{

private Long id;
private String idusuario;
private String idinstancia;
private String nombre;
private String idversion;
private String idproceso;
private String apellido;
private String username;
private String version;
private String proceso;
private long idUsuario;
private long idVersion;


public Userversion()
{
}

//Usuario

public class Usuario implements IDomainObject
{
private Long id;
private long identidad;
private boolean identidadNull = true;
private String username;
private String email;
private String nombre;
private String apellidopaterno;
private String apellidomaterno;

private Date fechaNacimiento;

/**
* Method 'Usuario'
*
*/
public Usuario()
{
}

You need to have an association mapped between UserVersion and Usario, it looks like you only have the entity mapped by just the id which isn't going to work.

Look at one-to-many and many-to-one in the reference documentation.