Topic: 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.