title: NHibernate + Criterias + DetachedCriteria
body: <p>I got this a problem, I need translate this SQL Query to Criteria, but I´m getting some troubles, any one can give a hand?</p>
  
  <p>SELECT * FROM Ref
  INNER JOIN Product Prod on Ref.id = Prod.id_referencia 
  AND Prod.ProdDtAlteracao = (SELECT MAX(Prod2.ProdDtAlteracao) FROM Product Prod2 WHERE Prod.ProdCod = Prod2.ProdCod)</p>