• 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
Posts: 12059
232
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
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!