distinct not working
536003Dec 18 2006 — edited Dec 19 2006Hi all, I have a query like this:
select d.a, d.b, d.c, d.d
from table d, (select key
from other_table) c
where d.key = c.key
and d.incorrect is null;
My problem is I only need distinct a, b, c, d values. When i put distinct on select, statement does not work, it keeps executing and it shows no result.
select distinct d.a, d.b, d.c, d.d
from table d, (select key
from other_table) c
where d.key = c.key
and d.incorrect is null;
What´s wrong? Thanks.