paul3

It's working!Thank You very much...

yeah, didnt think that will be so simple :)almost forgot, my table contains one more column - "date". so how do i select "date" for the values already selected using SELECT DISTINCT name, surname FROM table ?

hellothe query that i want to make is using one table. eg.:| name | surname ||----------------|| john | williams || jim | williams || jim | brown || ashley | brown || ashley | brown ||----------------|the selection should end in:| name | surname ||----------------|| john | williams || jim | williams || jim | brown || ashley | brown ||----------------|so if the "name" and "surname" is the same, i want to avoid that row.thank you