When (visually) defining a query with multiple joins, the AND conditions are messed. For instance, defining a query such as:
SELECT *
FROM tabA
INNER JOIN tabB ON condition1 AND condition2
INNER JOIN tabC ON condition3
this may result in:
SELECT *
FROM tabA
INNER JOIN tabB ON condition1
INNER JOIN tabC ON condition3 AND condition2
Description
When (visually) defining a query with multiple joins, the AND conditions are messed. For instance, defining a query such as: SELECT * FROM tabA INNER JOIN tabB ON condition1 AND condition2 INNER JOIN tabC ON condition3 this may result in: SELECT * FROM tabA INNER JOIN tabB ON condition1 INNER JOIN tabC ON condition3 AND condition2
Show »