inner join v/s join

[sayedsohail]

Hi,

 

Can someone explain the difference between inner join v/s join, Please.

 

thanks

[teng84]

i guess theres no difference between the two aside from declaring what type of join you want

[fenway]

i guess theres no difference between the two aside from declaring what type of join you want

 

JOIN implies INNER JOIN....

[teng84]

i guess theres no difference between the two aside from declaring what type of join you want

 

JOIN implies INNER JOIN....

 

yes i was thinking that way but i have tried join it self and it works and gives same output as inner join so i guess we cant say join implies inner join because join clause work without declaring what type of join you want

[fenway]

yes i was thinking that way but i have tried join it self and it works and gives same output as inner join so i guess we cant say join implies inner join because join clause work without declaring what type of join you want

 

What?

[teng84]

@fenway

you said join JOIN implies INNER JOIN....

 

but join it self works without inner join

i can do something like this

 

select * from table

join table1 on etccc....

 

also

select * from table

inner join table1 on etccc....

 

so i guess this question

Can someone explain the difference between inner join v/s join, Please.

deserve an answer (but not  join JOIN implies INNER JOIN.... )

 

well my bad because the only difference i knew about the two is what i have stated above

[btherl]

Fenway is saying that join and inner join are identical.  The reason he said "implies" is because JOIN means INNER JOIN, and never any other type of join.

 

You've probably noticed that the results are identical for every example you try.  That's because they ARE identical for every example in the universe

[Illusion]

Just like ORDER BY NAME ASC and ORDER BY NAME are same

 

JOIN defaults to INNER JOIN.