aspose file tools*
The moose likes JDBC 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
Bookmark "Minus Operation Query" Watch "Minus Operation Query" New topic
Author

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

Regards

Aravind Prasad
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

How about:


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
Don't get me started about those stupid light bulbs.
 
subject: Minus Operation Query