Anyone know why this select distinct returns multiple rows with the same value? Thanks so much! (the "-" is actually an "@" for a dblink.
SQL> select distinct CLAIM_DRIVER_STEPS.DATE_CREATED from CLAIM_DRIVER_STEPS
where DATE_CREATED not in (select DATE_CREATED from CLAIM_DRIVER_STEPS-cpedev);
DATE_CREA
---------
23-SEP-04
23-SEP-04
2 rows selected.
--
Thank You,
Frank Dodgers
Oracle & DB2 Certified
Evergreen Information Systems
-303-674-0433 Home
-303-810-6625 Cell
frank.[Email address protected]
Oracle LazyDBA home page