wood burning stoves 2.0*
The moose likes JDBC and the fly likes Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en" Watch "Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en" New topic
Author

Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en

Albert Hopkins
Greenhorn

Joined: Jul 21, 2007
Posts: 21
Hi...

I wrote



But, I got SQLException: ORA-00933: SQL command not properly ended message.

What I did wrong?? please
Swastik Dey
Rancher

Joined: Jan 08, 2009
Posts: 1467
    
    6

your sql evaluates to this

SELECT count(BLESS_SEVERITY) as sbmseverity3 from BLESS where BLESS_SEVERITY=3
AND bless_orno like '%_QSC_%' SELECT count(BLESS_SEVERITY) as no2 from bless);

and the above does not seem to be a valid sql.


Swastik
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61082
    
  66

Please take the time to choose the correct forum for your posts. This forum is for questions on JSP.

For more information, please read this.

This post has been moved to a more appropriate forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en