Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General 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
  • 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: 11877
195
C++ Firefox Browser IntelliJ IDE Java Mac Oracle
  • Likes 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
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic