On Tuesday 08 Oct 2002 7:19 pm, Charles Hauser wrote:
> Richard,
>
[snip]
> Is there a method to remove duplicate results? For instance the query
> below in part yields :
SELECT DISTINCT ... is what you're after. I'd do it in the views so the join
has less rows to compare against.
> chlamy_est-> ;
> contig_id
> -----------
> 27170
> 27173
> 27173
> 27179
> 27179
> 27179
> 27179
> 27179
--
Richard Huxton