Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: ww zz <ts_999@yahoo.com>, pgsql-sql@postgresql.org
Subject: Re: how to do this query?
Date: Tue, 20 May 2003 17:36:47 +0100
User-Agent: KMail/1.4.3
References: <20030520160011.81254.qmail@web41803.mail.yahoo.com>
In-Reply-To: <20030520160011.81254.qmail@web41803.mail.yahoo.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200305201736.47227.dev@archonet.com>

On Tuesday 20 May 2003 5:00 pm, ww zz wrote:
> New to sql and may be a simple question for you:
>
> I have four tables
>
> sample:   sid, sname
> make:     sid, mdate
> measure:  sid, mdate, rid
> result:   rid, resultdata
>
> for a gaven sample it always has a sid and sname, but
> it may or may not have any entries in the other
> tables, the sample could be measured more than once
> and each measure give a result row.

You'll want to use a LEFT JOIN, something like:

SELECT s.sid, s.sname, m.mdate, m.rid, r.resultdata
FROM sample s LEFT JOIN measure m ON s.sid=3Dm.sid LEFT JOIN result ON=20
m.rid=3Dr.rid

You'll get nulls where there are no matches.

--=20
  Richard Huxton