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: 222
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