Please login or register.

Login with username, password and session length
Advanced search  

News:

(2009-05-04) The Rules and Terms of Service have been updated. Please make sure you read, understand, and follow them.

Author Topic: inner join v/s join  (Read 529 times)

0 Members and 1 Guest are viewing this topic.

sayedsohail

  • Enthusiast
  • Offline Offline
  • Posts: 468
    • View Profile
inner join v/s join
« on: September 03, 2007, 07:29:50 AM »
Hi,

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

thanks
Logged

teng84

  • Fanatic
  • Offline Offline
  • Gender: Male
  • Posts: 3,530
    • View Profile
    • WWW
Re: inner join v/s join
« Reply #1 on: September 03, 2007, 08:09:09 PM »
i guess theres no difference between the two aside from declaring what type of join you want
Logged
<a href="http://teng.site88.net">teng</a>

fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Insane!'
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 11,605
    • View Profile
Re: inner join v/s join
« Reply #2 on: September 04, 2007, 04:08:55 PM »
i guess theres no difference between the two aside from declaring what type of join you want

JOIN implies INNER JOIN....
Logged
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

teng84

  • Fanatic
  • Offline Offline
  • Gender: Male
  • Posts: 3,530
    • View Profile
    • WWW
Re: inner join v/s join
« Reply #3 on: September 04, 2007, 08:54:14 PM »
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
Logged
<a href="http://teng.site88.net">teng</a>

fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Insane!'
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 11,605
    • View Profile
Re: inner join v/s join
« Reply #4 on: September 06, 2007, 06:01:32 PM »
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?
Logged
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

teng84

  • Fanatic
  • Offline Offline
  • Gender: Male
  • Posts: 3,530
    • View Profile
    • WWW
Re: inner join v/s join
« Reply #5 on: September 06, 2007, 07:28:53 PM »
@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
Logged
<a href="http://teng.site88.net">teng</a>

btherl

  • Guru
  • Addict
  • *
  • Online Online
  • Posts: 2,769
  • Matt is the best!
    • View Profile
Re: inner join v/s join
« Reply #6 on: September 06, 2007, 10:22:06 PM »
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 :)
Logged

Illusion

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 324
    • View Profile
Re: inner join v/s join
« Reply #7 on: September 07, 2007, 10:27:19 AM »
Just like ORDER BY NAME ASC and ORDER BY NAME are same

JOIN defaults to INNER JOIN.
Logged
"Free as in freedom, not beer."

PHP Freaks Forums

 
 
 

Page created in 0.052 seconds with 20 queries.