JOIN CONDITION

aGoram

on suggestion for join : Is it possible to have

SELECT * 
FROM table1 a
JOIN table2 b on b.id = a.id

-- instead of 

SELECT * 
FROM table1 a
JOIN table2 b on a.id = b.id

in my opinion , after the ON, it's more clear to put the JOIN KEY of the table b first

Anu D

Thanks for your post.

I have logged this as a faeture request (SP-2834) in our internal tracking system.

So that this can be considered as a release candidate in future.

Many thanks for your patience and co-operation.

PDinCA

If I can add a hearty "PLEASE DO THIS"... I go back and edit every JOIN I code for this precise reason...

Thanks for adding the enhancement request... When does voting start?

MikeyC

I'll just add my 5 cents, if you change it please make it an option, as we need it to stay working just like it is.

PDinCA

Absolutely agree with the "please make it an option"...