File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Can someone help me interpret a sql query please Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Can someone help me interpret a sql query please" Watch "Can someone help me interpret a sql query please" New topic
Author

Can someone help me interpret a sql query please

Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 483

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.


True wisdom is in knowing you know nothing - Socrates
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11404
    
  81

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?


The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 483

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
 
 
subject: Can someone help me interpret a sql query please
 
Similar Threads
Oracle JDBC Bug!
SQLQuery not working
how to pass array value in sql
Need help - Lot of joins are slowing down my query
Convert this SQL to EJB QL