Re: Getting matching and non-matching results (long) - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Getting matching and non-matching results (long)
Date
Msg-id 20011205130527.W17641-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Getting matching and non-matching results (long)  (Roberto Mello <rmello@cc.usu.edu>)
Responses Re: Getting matching and non-matching results (long)
List pgsql-sql
> 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?



pgsql-sql by date:

Previous
From: "Aasmund Midttun Godal"
Date:
Subject: Re: INT OR VARCHAR
Next
From: Jan Wieck
Date:
Subject: Re: PL/pgSQL examples NOT involving functions