Re: SQL Query

[Rob Berendt <rob@xxxxxxxxx>]

This is what I did.  
SELECT * from listfile
WHERE SrcLib, SrcFile, SrcMbr IN(             
SELECT SrcLib, SrcFile, SrcMbr FROM listfile
GROUP BY Srclib, SrcFile, SrcMbr
HAVING COUNT(*) > 1)    




venu_yamajala@goodyear.com on 03/08/99 11:05:21 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      

Subject:        SQL Query

Hi All,

Simple question. Banging my head for a long time.. not able to get the results
I wanted.. Let me explain my situation. I have a file with the following
structure -

ObjLib, ObjName, ObjAttr, SrcLib, SrcFile, SrcMbr

I have cases like 1) same source but created as two different objects and the
normal src-obj relationship. I want to list out only the records that hae case
1). i.e, different objects created from same src.

Not able to break this.. Any help/suggestions... TIA.

Rgds
Vg
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---