From: | ww zz <ts_999(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | how to do this query? |
Date: | 2003-05-20 16:00:11 |
Message-ID: | 20030520160011.81254.qmail@web41803.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
question:
how do I do a query that given a sid, it will retrieve
all the information available in the four tables, if
there are available. If, for example, all tables have
some entry for a gave sample it will retreve all the
information, if the "measure" and "result" are empty
for that sample it will give only the 'sample' and
'make' information....
please help
Thanks
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-05-20 16:04:36 | Re: Performance on temp table inserts |
Previous Message | Achilleus Mantzios | 2003-05-20 15:16:20 | Re: Drop CONSTRAINT |