Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sylvia Moestl Vasilik Enhancing the readability of your code: Table aliasing in sql RE: Enhancing the readability of your code: Table aliasing in sql

  • May 7, 2009 at 5:41 am

    #990247

    Hi, Sylvia

    I totally agree with you, many of the developers are using meaningless aliasing and that would be very tough to debug in future and waste of time. even i found some developers are not using proper indentation. It will be always good practice to provide proper indentation like below

    SELECT Table1.Field1, Table1.Field2,

    Table2.Field3, Table2.Field4,

    FROM Table1

    LEFT OUTER JOIN Table2 ON Table2.Field1 = Table2.Field3

    WHERE Table1.Field1 = CompareValue1

    AND Table2.Field3 = CompareValue2

    Also it is good practice to provide the syntax / reserved words in Upper case for better readability.