Received: from lsanca1-ar1-012-112.dsl.gtei.net (IDENT:root@lsanca1-ar1-012-112.dsl.gtei.net [4.35.12.112]) by hub.org (8.10.1/8.10.1) with ESMTP id e5LNrm116419 for ; Wed, 21 Jun 2000 19:53:48 -0400 (EDT) Received: from earthlink.net (IDENT:x@lsanca1-ar1-012-112.dsl.gtei.net [4.35.12.112]) by lsanca1-ar1-012-112.dsl.gtei.net (8.9.3/8.8.7) with ESMTP id QAA03850 for ; Wed, 21 Jun 2000 16:53:41 -0700 Message-ID: <39515585.308A428C@earthlink.net> Date: Wed, 21 Jun 2000 16:53:41 -0700 From: Francisco Hernandez X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: eliminating duplicates in results.. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/190 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..