Order of joins is not maintained in the query editor
Brought to you by:
nickyb
http://jira.pentaho.com/browse/PRD-2374
The order of joins in the generated SQL code is not the same as in the definition in the visual editor. This can bring to a serious loss of performance (even preventing the execution of the query).