RE: SQL Query

Try this it will work!!!!.

SELECT DISTINCT a.name
FROM emp AS a, emp AS b
WHERE a.name = b.name and a.empno <> b.empno

name = SRCNM empno = OBJNM emp = Physical file.

Bye
> -----Original Message-----
> From: VENU YAMAJALA [SMTP:venu_yamajala@goodyear.com]
> Sent: Monday, March 08, 1999 8:50 PM
> To:   MIDRANGE-L@midrange.com
> 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
+---