This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 1449
    
    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: 60810
    
  65

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]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en
 
Similar Threads
delete sql
Many ResultSet. How to do layout???
Right Outer Join in Oracle
how to fetch data from resultset containing result of two queries
iBatis and Parameter Map