This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can someone help me interpret a sql query please

 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The query is:

The portion that I am having trouble interpreting is the last and

What is the last and wanting ORG_ID to equal (or not equal)?


Or a little help on how to interpret this myself would work too. How would I break this down into smaller parts to evaluate from the inside out? I will figure it out with more time, but would definitely like some assistance if anyone is willing.
 
Andrew Monkhouse
author and jackaroo
Marshal Commander
Pie
Posts: 11833
181
C++ Firefox Browser IntelliJ IDE Java Mac Oracle
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Matt

I split your SQL into multiple lines, and added indentation so that it is hopefully a little clearer what is being compared.

Does this help?
 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, very much. I should have tried to do that myself, I was just feeling lazy at the time because I had been at debugging for about 10 hours straight.

Thanks for humoring my laziness
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic