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;
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?
