Thread: eliminating duplicates in results..

hello everyone,
i have a query like so:

select item.type as ig_id,item.with_design,item_group.type as
group_name, 'true' as valid from item,item_group where item.description
~* 'w/out' and item.type = item_group.ig_id;

and i get duplicates.. how could i remove all the duplicate entrys using
SQL?
the duplicates are fine.. im just trying to migrate data from one table
to another.. with columns renamed and some added/removed..

SELECT DISTINCT

On Wed, 21 Jun 2000, Francisco Hernandez wrote:

> hello everyone,
> i have a query like so:
> 
> select item.type as ig_id,item.with_design,item_group.type as
> group_name, 'true' as valid from item,item_group where item.description
> ~* 'w/out' and item.type = item_group.ig_id;
> 
> and i get duplicates.. how could i remove all the duplicate entrys using
> SQL?
> the duplicates are fine.. im just trying to migrate data from one table
> to another.. with columns renamed and some added/removed..
>