Your reports may produce slow
responses or generate inconsistent results. If a report contains inconsistent or incorrect
results, and the SQL command contains several joins, make sure the join order has been
specified for that report.
Beginning in version 5.0, inner joins are resolved before outer joins. If you have several tables that require outer joins, the order in which the tables are joined is critical because different join orders produce different results. To make the join order consistent, set the Join Order Key field in the Relationship Properties window. For more information, see: Managing multiple outer-joins.