Criteria的休眠映射问题

String sqlQuery = \"SELECT {msg.*},  {cmd.*} \" +
    \"FROM schemaName.Messages AS msg \" +
    \"LEFT OUTER JOIN schemaName.send_commands AS cmd \" +
    \" ON cmd.message_key = msg.unique_key \" +
    \" AND ( cmd.priority = 1 ) \" +
    \"WHERE msg.sequence_received < 10\";

Query query = session.createSQLQuery( sqlQuery )
          .addEntity( \"msg\",Messages.class )
          .addJoin( \"cmd\",\"msg.commands\" )
          .addJoin( \"msg\", \"cmd.message\" );
query.setResultTransformer( Criteria.DISTINCT_ROOT_ENTITY );

Criteria crit = session.createCriteria( Messages.class )
     .add( Restrictions.lt( \"sequenceReceived\", Long.valueOf( 10 )) )
     .setFetchMode( \"commands\", FetchMode.JOIN )
     .createAlias( \"commands\", \"cmd\", Criteria.LEFT_JOIN, Restrictions.eq( \"cmd.priority\", 1 ) )          
     .setResultTransformer( Criteria.DISTINCT_ROOT_ENTITY );

SELECT  [...]
FROM schemaName.Messages AS msg LEFT OUTER JOIN schemaName.send_commands AS cmd  
ON cmd.message_key = msg.unique_key  AND ( cmd.priority = 1 ) 
WHERE msg.sequence_received < 10