When I execute a query, with a RIGHT JOIN - clause (Select * from Table1
right join Table2 on... ), it returns the correct fields:all from Table2
and the matching fields from Table1.
When I execute the same query for two other tables, it only returns the
By analyzing the query in the Query-Analyzer, I found out, that the
wrong results were generated with a HASH-JOIN, while the correct results
were generated with NESTED-LOOPS-JOINS.
As I deleted most of the rows of the (left) table, the results became