JOIN CONDITION

aGoramaGoram Posts: 18
edited October 9, 2009 6:45PM in SQL Prompt Previous Versions
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

Comments

  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • PDinCAPDinCA Posts: 642 Silver 1
    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?
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • MikeyCMikeyC Posts: 249 Bronze 3
    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.
  • PDinCAPDinCA Posts: 642 Silver 1
    Absolutely agree with the "please make it an option"...
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
Sign In or Register to comment.