Re: SQL Dilemma!! Anyone.........

From: Kbat <kbatsche_at_yahoo.com>
Date: Thu, 9 Dec 1999 21:22:16 -0700
Message-ID: <82puvg$g66$1@nnrp02.primenet.com>

Try
select a.name, count(b.name) as entry_count from users a, log b
where a.name+ = bname

ignore anthony

<hallian_at_hotmail.com> wrote in message news:82pq03$2bb$1_at_nnrp1.deja.com...
> Hi SQL[ers],
>
> Is this possible to do in SQL with just my 2 tables:
> First Table: users
> Second Table: log
>
> USERS TABLE [1 FIELD] name
> sam
> john
> jack
> miller
>
> LOG TABLE [3 FIELDS] rec_no name desc
> 1 sam happy
> 2 jack unhappy
> 3 sam jolly
> 4 miller happy
> 5 sam smiley
> 6 john unhappy
>
> Now can I use SQL statements to loop through each entry from Table:
> USERS against each entry against Table: LOG. Is it possible!!!!
>
> sam 3 entries
> jack 1 entry
> miller 1 entry
> john 1 entry
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 09 1999 - 22:22:16 CST