Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA86049 for ; Thu, 1 Jul 1999 12:59:35 -0400 (EDT) (envelope-from matthew@venux.net) Received: from thunder (net177138.hcv.com [209.153.177.138]) by redbox.venux.net (Postfix) with SMTP for id EB4042E20B; Thu, 1 Jul 1999 12:55:39 -0400 (EDT) Message-Id: <4.1.19990701124526.00c0bab0@mail.venux.net> X-Sender: mhagerty@mail.venux.net X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Thu, 01 Jul 1999 13:00:23 -0400 To: pgsql-sql@postgreSQL.org From: Matthew Hagerty Subject: DISTINCT on multiple fields Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Greetings, I need a query that will remove duplicate records if three fields are the same, i.e. the name, address, and VIN. I have been messing around with DISTINCT and DISTINCT ON but I cannot get the results I'm looking for. Thank you, Matthew