Received: from websales.com (IDENT:root@websales.com [192.153.125.97])
	by hub.org (8.9.3/8.9.3) with ESMTP id UAA86328
	for <pgsql-sql@postgresql.org>; Tue, 7 Dec 1999 20:04:38 -0500 (EST)
	(envelope-from cgriffin@websales.com)
Received: from [207.67.207.131] (webcc-isdn-131.webcc.net [207.67.207.131])
	by websales.com (8.9.3/8.8.5) with ESMTP id RAA29743
	for <pgsql-sql@postgresql.org>; Tue, 7 Dec 1999 17:07:44 -0800
User-Agent: Microsoft Outlook Express Macintosh Edition - 5.0 (1513)
Date: Tue, 07 Dec 1999 17:03:52 -0800
Subject: select distinct?
From: Chris Griffin <cgriffin@websales.com>
To: <pgsql-sql@postgresql.org>
Message-ID: <B472EE78.1247%cgriffin@websales.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit


 I have two tables. One has job candidate information (name, salary, area of
experience, etc.). The other table contains jobs. I am searching on 4
different fields. I want a list of candidates that match at least one job.
So all 4 fields have to match. Of course I want each candidate only once. I
have tried using distinct on the key field but I get an error. I can't seem
to figure out how to use group by in this situation either. Any help would
be great! Thanks.