> select distinct a as F from table
> select distinct b as F from table;
Note that UNION only returns the unique values of the union
You can get repeated values by using UNION ALL.
Edmund Bacon <ebacon(at)onesystem(dot)com>
Next:From: Jaime CasanovaDate: 2004-05-13 18:13:23
Subject: isolation level
Previous:From: StefDate: 2004-05-13 14:49:36
Subject: Re: Exceptions when 0 rows affected.