Sandor Szollosi wrote:

> 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

I'm not sure if I did quite understand you, but try this:

select distinct FIELD1 from TBL1
union
select distinct FIELD2 from TBL1

--
Milan Babuskov
http://fbexport.sourceforge.net