Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Union query

Union query

From: Abu Hamza <ali711_at_sunnipath.com>
Date: 12 Dec 2006 02:57:21 -0800
Message-ID: <1165921041.738399.38750@16g2000cwy.googlegroups.com>


I have a query of the form

query1 union query2

Both queries have a common field f1.
My problem is to get only those records from query2 which have a corresponding record (same f1 value) in query1. In other words there should be no record in query2 that has x in f1 and there does not exist an x in query1. Is there a simple way or do I have to write a complex 'exists' condition in query2 ?

thx. Received on Tue Dec 12 2006 - 04:57:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US