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!