DISTINCT in UNION does not work

Hello Deja community:
Here is something to challenge your mind,

SELECT DISTINCT INV.INVEST_SEQ_NBR,
FROM INVESTIGATION INV
UNION
SELECT DISTINCT INV.INVEST_SEQ_NBR,
FROM INVESTIGATION INV I am getting duplicate rows back with same INV.INVEST_SEQ_NBR. I was wondering how can I apply DISTINCT on the result set returned by UNION. As you can see, in above query DISTINCT is appllied to each query but on the final result set. Your assitance is appreiciated. Send reply to shaikh74_at_visto.com
Thanks
Asad

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 09 2000 - 11:17:36 CST