From: | daniel holtzman <daddy2times(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | I'll try again: multiple joins |
Date: | 2001-12-07 07:15:03 |
Message-ID: | 20011207071503.72064.qmail@web10907.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I know the problem in query #2 is that I'm restricting
the results to only rows which satisfy the additional
WHERE... a.surid = $surid AND // PHP again
and therefore I'm not getting the rows where that
expression would return NULL, but I can't seem to get
my SQL (no _bad_ pun intended!) around how to treat
that restriction. Could it be that I need to do some
sub-selecting? How?
> [sorry for the length of this post, but I have many
> tables and big queries ;-)]
[please see previous post for details]
Thanks,
__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2001-12-07 08:59:52 | Re: Storing number '001' ? |
Previous Message | Samudra E Haque | 2001-12-07 03:29:57 | Re: Number of days in a month |