class Entity1
{
  public int Id;
  public string Name;
}
class Entity2
{
  public int Id;
  public string Name;
}

SELECT e1
  FROM Entity1 e1, 
       Entity2 e2 
  WHERE e1.Name = e2.Name
        AND
        e2.Id IN ( :Ids )

var dc = DetachedCriteria
  .ForEntityName( "Entity2" )
  .Add( Restrictions.InG( Projections.Id(), Ids ) )
  .SetProjection( Projections.Property( "Name" ) );

var criteria = session
  .CreateCriteria( "Entity1" )
  .Add( Subqueries.PropertyIn( "Name", dc ) );

class Entity
{
  public int Id;
  public string Name;
  public long Type;
}

SELECT e1
  FROM Entity e1, 
       Entity e2 
  WHERE e1.Name = e2.Name
        AND
        e1.Type = e2.Type
        AND
        e2.Id IN ( :Ids )