and how (exactly) you want to pull the data.
--
Loren McDonald
[EMAIL PROTECTED]
> -Original Message-
> From: Hoffman, Geoffrey [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, January 25, 2003 3:48 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Need nulls in my join
>
>
Hi.
On Sat 2003-01-25 at 14:25:14 -0400, [EMAIL PROTECTED] wrote:
> On Fri, 2003-01-24 at 20:27, Hoffman, Geoffrey wrote:
[...]
> > It's returning only stories in a section that have photos,
> > but I need it to return all the stories in a section whether
> > it has a photo or not.
> >
> > I th
PHP loop, but it works fine for now.
Thanks though - I'm sure I'll use your suggestion somewhere in the app I'm
working on.
Geoff
> -Original Message-
> From: Loren McDonald [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, January 25, 2003 1:41 PM
> To: Hoffman, Ge
Oopssorry. That should have been GROUP BY and not GROUP ON
That's what I get for answering a post at 2am. :)
--
Loren McDonald
[EMAIL PROTECTED]
> This one is relatively simple:
>
> Drop the WHERE evtphoto.phtusage = 1.
> SELECT it and then GROUP ON it.
>
> --
> Loren McDonald
--
On Fri, 2003-01-24 at 20:27, Hoffman, Geoffrey wrote:
> I have an SQL query that LEFT JOINs four different tables to a main table,
> based on several foreign keys.
>
> It's returning only stories in a section that have photos,
> but I need it to return all the stories in a section whether
> it
t: Friday, January 24, 2003 7:28 PM
> To: [EMAIL PROTECTED]
> Subject: Need nulls in my join
>
> I have an SQL query that LEFT JOINs four different tables to a main
table,
> based on several foreign keys.
>
> It's returning only stories in a section that have photos
I have an SQL query that LEFT JOINs four different tables to a main table,
based on several foreign keys.
It's returning only stories in a section that have photos,
but I need it to return all the stories in a section whether
it has a photo or not.
I think the problem is in the
WHERE evtphoto
