Inner Join vs Left Join
View Single Post
08-05-2008, 10:48 PM
is cute and cuddly
Join Date: Mar 2008
Location: Vegas, Baby
With MySQL, the "OUTER" keyword is optional. It's provided for ODBC compatibility and doesn't add any extra capabilities.
Okay, so yes, if I want to make my queries compatible with other SQL databases, I want to include the OUTER keyword, correcto? Eventually I want to build, or incorporate an abstraction layer, and I want to make sure it migrates with as little fuss as possible. I'd get it done now, but my to do list is about a mile long and lost somewhere in my bedroom. Which isn't a mile long. Nonetheless, it's lost.
View Public Profile
Send a private message to delayedinsanity
Visit delayedinsanity's homepage!
Find More Posts by delayedinsanity