File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Minus Operation Query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Minus Operation Query" Watch "Minus Operation Query" New topic

Minus Operation Query

Aravind Prasad
Ranch Hand

Joined: Dec 28, 2005
Posts: 265
Dear Ranchers,
I'm using JSP and MySQL for my project. In a particular point I've a query which i want to use the minus opertions..

I want to run a query which selects the values from main_table and compare the value with sub_table and display the values which are not in the sub_table

In oracle I can use a MINUSwhich can help me in doing this

But I'm using MySQL. Please help me..

The Query is

Please help me how can I use the query in MySQL


Aravind Prasad
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

How about:

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: Minus Operation Query
It's not a secret anymore!