DISTINCT does not work ?
Posted on 2007-08-02
I have a query and it´s working ok, but i need to get rid of those doubles i get from database.
i thought that DISTINCT would help me this one, but result is same with distinct or without. Is there something wrong my clause:
SELECT DISTINCT Atmtil_0.Tukoodi, Atmtil_0.Atkno, Atmtil_0.Atyks, Atmtil_0.Atnet
FROM PUB.Atmtil Atmtil_0
WHERE (Atmtil_0.Atkno>=200704 And Atmtil_0.Atkno<=200706)
Database is progress running with linux. And i use exel MS query.