Page 1 of 1

[what's the default here?] JOIN

Posted: Tue Mar 31, 2009 7:11 pm
by JellyFish
I was wondering what the kind of join is a join when you write just JOIN, without anything in front of it, such as, INNER or CROSS. In other words, what is the default type of join when you don't specify anything in front of the keyword JOIN in a SQL query?

Just a quick question I wasn't able to find answered at MySQL.com.

Re: [what's the default here?] JOIN

Posted: Wed Apr 01, 2009 2:25 pm
by volomike
INNER JOIN, and the same thing as a comma:

http://dev.mysql.com/doc/refman/5.0/en/join.html

http://forums.mysql.com/read.php?20,213 ... msg-213755

But don't believe me -- try it for yourself with some sample data.

Re: [what's the default here?] JOIN

Posted: Thu Apr 02, 2009 10:21 am
by JellyFish
Oh okay. Thanks for that.

INNER and CROSS are both the same right? And they both produce a Cartesian products (that is, without a ON or USING clause)?

Re: [what's the default here?] JOIN

Posted: Thu Apr 02, 2009 10:33 am
by VladSun