Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB5L7Jm00536 for ; Wed, 5 Dec 2001 16:07:19 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 89AF8D5EB; Wed, 5 Dec 2001 13:07:20 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 7D5D95BEA; Wed, 5 Dec 2001 13:07:20 -0800 (PST) Date: Wed, 5 Dec 2001 13:07:20 -0800 (PST) From: Stephan Szabo To: Roberto Mello Cc: Subject: Re: Getting matching and non-matching results (long) In-Reply-To: <20011205123703.A2725@cc.usu.edu> Message-ID: <20011205130527.W17641-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/58 X-Sequence-Number: 5881 > create table sds_grades ( > grade_id integer > constraint sds_grades_pk primary key, > grade_name varchar(100) > ); > > create table sds_offenders ( > offender_id integer > constraint sds_offenders_pk primary key, > participant_id integer > constraint sds_offenders_part_id_fk references sds_participants, > incident_id integer > constraint sds_offenders_incident_id_fk references sds_incidents on delete cascade, > unknown_count integer, > grade_id integer > constraint sds_offenders_grade_id_fk references sds_grades, > ... > ); > > SELECT COUNT(incident_id), drug_name, grade_name > FROM sds_offenders o, sds_drugs d, sds_drug_offenses do, sds_grades g > WHERE o.drug_p = 't' > AND o.offender_id = do.offender_id > AND d.drug_id = do.drug_id > GROUP BY drug_name, grade_name, d.sort_key > ORDER BY d.sort_key I think you need a g.gradeid=o.gradeid in the where clause as well to constrain g to the grade for which the offender belonged, right?