What are the differences between these?

Posted by Amit Ranjan on Stack Overflow See other posts from Stack Overflow or by Amit Ranjan
Published on 2012-10-08T15:32:29Z Indexed on 2012/10/08 15:37 UTC
Read the original article Hit count: 223

Filed under:
|
|
|

What are the differences between the two queries?

   SELECT     CountryMaster.Id
   FROM       Districts INNER JOIN
   CountryMaster ON Districts.CountryId = CountryMaster.Id

   SELECT     CountryMaster.Id
   FROM       CountryMaster INNER JOIN
   Districts ON Districts.CountryId = CountryMaster.Id  

Please mind the i) Table positions and second ii) On Fields

As I know, output will be same. But I want to know, is there any drastic effects of the same if I neglect positions of tables and columns in complex queries or tables having tons of data like thousands and lakhs of rows...

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server