How to use inner join with hql query

[Fabio Cunha]

I want to construct a hqlquery using hibernate.

I need join two tables, city and state, and one single table to use him to show in a data table in my JSF application, can anybody helpme construct a criteria or hqlquery to join my table

[Paul Sturrock]

HQL and SQL are very similar. What have you got so far?

[Fabio Cunha]

I already create a criteria to list my class

package br.salesianos.lista;
import br.salesianos.db.*;
import br.salesianos.modelo.*;
import java.util.List;
import javax.faces.bean.ManagedBean;
import org.hibernate.Session;
@ManagedBean
public class ListaEstado {
private List suaLista;
public ListaEstado() {
filtrar();
}
public void filtrar() {
Session sessao = CriadorDeSessao.getSession();
suaLista = (sessao.createCriteria(Estado.class).list());
sessao.close();
}
/**
* @return the suaLista
*/
public List getSuaLista() {
return suaLista;
}
/**
* @param suaLista the suaLista to set
public void setSuaLista(List suaLista) {
this.suaLista = suaLista;
}*/
}

and i use this to show him in my xhtml file

<h:dataTable border="1" var="item" value="#{listaEstado.suaLista}">
<h:column>
<h:outputText value="#{item.est_sigla}" />
</h:column>
<h:column>
<h:outputText value="#{item.est_nom}" />
</h:column>
</h:dataTable>

it works, but now i want to mix two tables(using inner join or something) to show in my datatable

[Arun Kumarr]

Create a SQL or HQL query as you always do and try converting mapping the resultset values into your custom class.
Check Transformers.aliasToBean method. See if it helps.