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..