Re: Help!!! Complex SQL (For Pros Only)

From: <bonanos_at_yahoo.com>
Date: Mon, 21 Jun 1999 13:08:16 GMT
Message-ID: <7kldfp$9m3$1@nnrp1.deja.com>

In article <376e14c8.0_at_145.227.194.253>, "Mark Gumbs" <mgumbs_at_nospam.hotmail.com> wrote:
> I haven't actually tried the code out but....

> select
> h.id_code Header_code,
> h.descr Description,
> count(c.id) Content_Count,
> count(l.id) Link_Count
> from
> Links l,
> Content C,
> Header H
> where
> H.id_code = C.header_code
> and H.id_code = L.header_code
> group by
> ID_code, Descr
>

Hi That's what I tried intially but it didn't work. I tried Sybrands example and it is ok.

Thanks Sybrand!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 21 1999 - 08:08:16 CDT