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 -> How to return records with mismatching criteria in the same column

How to return records with mismatching criteria in the same column

From: D <email0203_at_comcast.net>
Date: 6 Apr 2007 10:26:05 -0700
Message-ID: <1175880365.260684.90740@d57g2000hsg.googlegroups.com>


Hello everyone. I have result set that I am pulling that shows a customer may have a different end date on multiple records. Is there a way to compare the values in the column and say if account number and customer and end date match, do not return values - but if account number and customer match but end date does not match all records for that account number and customer return all values for that customer? here is what I have so far and what I'm looking to do...

SELECT /*+ first_rows(10) */ c.ACCTCORP, c.HOUSE, c.CUST, c.lname, c.fname, hsa.SVC_AVL_TYPE, cp.promocode, cp.stopdate FROM IDST_CUSTOMER c, IDST_HOUSE_SERVICE_AVLBLTY hsa, IDST_CUST_PROMO cp
WHERE c.acctcorp=hsa.acctcorp AND c.house=hsa.house AND c.acctcorp=cp.acctcorp AND c.house=cp.house AND c.cust=cp.cust AND c.acctcorp=9518 AND hsa.svc_avl_type=59 AND cp.promocode IN ('! X','<3','<8','<G','<N','<O','<P','<Q','<R','<S','>9','CM','CN','CS','CT','CY','H>','N<','O<','P<','U4','U5','U6','U7','U8','U9','UB','UC','UD','UE','UF','UG') ORDER BY c.acctcorp ASC, c.house ASC

THE RESULTS I'M LOOKING TO RETURN...

9518	100256	6	PEARSON	JAMES	59	!X	1/25/2008
9518	100256	6	PEARSON	JAMES	59	UF	1/25/2008
9518	100256	6	PEARSON	JAMES	59	CS	2/27/2008

The first two values match but the 3rd is different...I want to display all three records for this type of record set only. Received on Fri Apr 06 2007 - 12:26:05 CDT

Original text of this message

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