Hi all,

I have a small problem with distincted query:

FIELD1, FIELD2
1,1
1,2
2,1
2,2

Result of
"select distinct FIELD1 from TBL1":
1
2

and result of
"select distinct FIELD1,FIELD2 from TBL1":
1,1
1,2
2,1
2,2

But I'd like to get two field in result and only two row.
I don't mined which value will show in the second column

TIA
Szasa