More freedom for join conditions

By Francisco Pires on 1 Feb 2013
Simple Queries would gain a lot of value if you could have more freedom to define join (on) conditions. When you try to change the join condition (for example, adding another), it is automaticallty converted into a "where".  

This is specially bad when you want to define outer joins because the behaviour of having a "where" condition and an "on" condition is different, as it may cause the join to behave like an inner join, even if you check for nulls.

A lot of times I had to convert very simple queries (for example, 1 left join with 2 conditions)  to advanced because of this.

This would also be very useful in terms of SQL performance.
Manuel1 Feb 2013
i would love to see the possibility for DISTINCT simple query's too