Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

MySQL - syntax learning question  RSS feed

 
Patrick Perrin Smith
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello, folks.

I'm currently in the process of trying to teach myself to use MySQL. And in said process, I've ran upon a problem:




This was my query to my database.

To see the query with fancy colored words, and what database I'm querying, go to:

http://sqlfiddle.com/#!2/1943b/68

Now the problem is that I've messed up somewhere in the joining-syntax.

But I'm not exactly sure where...

Does anyone see my error?
 
K. Tsang
Bartender
Posts: 3639
16
Firefox Browser Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Syntax wise there is no problem. However, MySQL does NOT support full outer joins. Personally I didn't realize that until now.

Check out here to see one way to simulate full outer join.
 
Patrick Perrin Smith
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
K. Tsang wrote:Syntax wise there is no problem. However, MySQL does NOT support full outer joins. Personally I didn't realize that until now.

Check out here to see one way to simulate full outer join.


Ah, see that explains it!

Thank you!
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!