join and inner join

[dotJoon]

myTable24

(m) id
(1) Tom 
(2) Kojack 
(3) Jimmy 
(4) Mary 

myTable25

(s) top          say                            tm
(1) America    I like America                    1
(2) France     I am from France                  4
(3) 1          I visited New York yesterday      3
(4) China      China is good                     3
(5) 1          Chicago is a city                 2
(6) 2          Paris is beutiful                 1

I have myTables like the above.

code1

select s, top, say, tm,id

from myTable25
join  myTable24 on tm=m

where id like '%#variables.w#%'


code2
select s, top, say, tm,id

from myTable25
inner join  myTable24 on tm=m

where id like '%#variables.w#%'

The both code1 and code2 have the same results.

What is the different between join and inner join or which is correct?

[r937]

Originally Posted by joon

What is the different between join and inner join or which is correct?

there is no difference

in recent versions of mysql, INNER is an optional keyword, but in earlier versions, if you didn't say INNER, you ended up getting a CROSS JOIN

this is why i always recommend using the optional keywords anyway -- it adds to clarity, and avoids problems

so, always say INNER JOIN instead of JOIN, and always say LEFT OUTER JOIN instead of LEFT JOIN