List:General Discussion« Previous MessageNext Message »
From:(Hal Date:August 2 2011 2:52pm
Subject:Too many aliases
View as plain text  
>>>> 2011/08/02 12:11 +0530, Adarsh Sharma >>>>
select p.* from table A p, B q where p.id=q.id

or

select p.* from table B q , A p where q.id=p.id
<<<<<<<<
Why do people constantly change table names for queries, although, as here, it gain them
nothing? It often makes for less clarity (for which table is this an alias???). This I
would write

select A.* from A JOIN B USING (id)

Thread
Which is betterAdarsh Sharma2 Aug
  • RE: Which is betterShafi AHMED2 Aug
  • Too many aliaseshsv2 Aug
    • Re: Too many aliasesRik Wasmus3 Aug
      • RE: Too many aliasesDavid Lerer3 Aug
        • RE: Too many aliasesshawn wilson3 Aug
        • RE: Too many aliasesJerry Schwartz4 Aug
      • Re: Too many aliaseshsv4 Aug
        • RE: Too many aliasesDavid Lerer4 Aug
          • Re: Too many aliasesMike Diehl4 Aug
            • Re: Too many aliasesJohnny Withers4 Aug
              • Re: Too many aliaseshsv6 Aug
                • Re: Too many aliasesJohnny Withers7 Aug
  • Re: Which is betterMySQL)2 Aug
    • RE: Which is betterDavid Lerer2 Aug
Re: Which is betterPrabhat Kumar2 Aug