Steve Jones - Editor (5/27/2009)

---

The corrected question, which is on the web site, is

CREATE TABLE E (eid int, mid int, en char(10) )
INSERT E SELECT 1,2,'Vyas'
INSERT E SELECT 2,3,'Mohan'
INSERT E SELECT 3,NULL,'Shobha'
INSERT E SELECT 4,2,'Shridhar'
INSERT E SELECT 5,2,'Sourabh'
 
SELECT t1.en [Em], t2.en [Ma] FROM E t1, E t2 WHERE t1.mid = t2.eid
 order by t1.en

There is no way you can get "Vyas Mohan" first.

Running the SQL from the newsletter kind of defeats the purpose in answering. The idea is for you to use your knowledge to figure it out.

Barry McConnell (5/27/2009)

---

I typically read the email, solve the problem in my head, click the link and select the answer I got.

SanjayAttray (5/27/2009)

---

WOW.........never seen so many complaints for a single question on QOD before. Good job Reddy. You made all forum posters stand united.

cj_logan (5/27/2009)

---

Question

Why is the inner join the recommended option ? I know Microsoft recommends this way but no where can I find a reason ? According to the execution plan both are the same and both cost 50%

SELECT t1.en [Em], t2.en [Ma] FROM E t1, E t2 WHERE t1.mid = t2.eid
order by t1.en

SELECT t1.en [Em], t2.en [Ma] FROM E t1 inner join E t2 on t1.mid = t2.eid
order by t1.en