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 -> Complicated query

Complicated query

From: Nick <nachiket.shirwalkar_at_gmail.com>
Date: Thu, 06 Sep 2007 10:28:34 -0700
Message-ID: <1189099714.276642.318680@50g2000hsm.googlegroups.com>


Hi,

I have two tables Trade table and Cons table. Records are inserted in both the tables independent of each other. There are fields like Exc_Ref, Qty, Date in both the tables.

I need to write a query which should give me records :

  1. Where there is missing Exc_Ref value in either of the table. i.e. If Trade table has a Exc_Ref value but missing in Cons table then that record should be displayed. Similarly if Cons has a Exc_Ref value which is not found in Trade table then that too should be displayed.
  2. In case where both the tables have matching Exc_Ref data then it should display the record only when the remaining column does not match like Qty or Date.

Please help me to resolve this complicated query.

Thanks
Nick Received on Thu Sep 06 2007 - 12:28:34 CDT

Original text of this message

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