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.
[what's the default here?] JOIN
Moderator: General Moderators
- volomike
- Forum Regular
- Posts: 633
- Joined: Wed Jan 16, 2008 9:04 am
- Location: Myrtle Beach, South Carolina, USA
Re: [what's the default here?] JOIN
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.
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
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)?
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
Take a look at viewtopic.php?f=2&t=95398
There are 10 types of people in this world, those who understand binary and those who don't