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