How can we help you today? How can we help you today?

JOIN CONDITION

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
aGoram
0

Comments

4 comments

Sort by
  • 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.
    Anu D
    0
  • 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?
    PDinCA
    0
  • 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.
    MikeyC
    0
  • PDinCA
    Absolutely agree with the "please make it an option"...
    PDinCA
    0

Add comment

Please sign in to leave a comment.