Inner join vs join

Asked Jul 26 '12 at 04:49

Active Jul 26 '12 at 11:43

Viewed 179 times

Possible Duplicate:
Difference between JOIN and INNER JOIN

Did read this....but there is a difference if you look at my question. I have asked why DOES NOT THIS WORK......that link has all the explanations only.......

String sql ="SELECT s.text, s.postdate,"+
        "d.Fname FROM Wall s " +
        "join Kid_Register d on d.id=s.fromsl";// this works

String sql ="SELECT s.text, s.postdate,"+
        "d.Fname FROM Wall s " +
        "inner join Kid_Register d on d.id=s.fromsl"; // this does not

Can I know the reason why? As far as my research on the net it says that inner join and join are the same and as one put in SO the diff is just the "syntactical sugar" part....

edited May 23 '17 at 12:13

Community

asked Jul 26 '12 at 04:49

Kunal Shah

@Siddiqui but the question is why is he getting no rows for the second version – Bohemian Jul 26 '12 at 04:54
@Bohemian, oh sorry, I have deleted my comment. – Siddiqui Jul 26 '12 at 04:57
What version of SQL server do you use? – Andrey Stukalin Jul 26 '12 at 05:50
@KunalShah 5.0 what? What database are you testing this on? – Grzegorz W Jul 26 '12 at 06:14
@GrzegorzWilczura It is MySQL v.5.0.0 – Kunal Shah Jul 26 '12 at 11:40
@astandr How is this a duplicate? Could you read my question...I dont want to know the difference, I want to know why does not it work....... – Kunal Shah Jul 26 '12 at 11:46

Inner join vs join

0 Answers0