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