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

<hallian_at_hotmail.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ 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.

select a.name, count(b.name), decode(count(b.name),1,'entry','entries') from table1 a, table2 b
where a.name(+) = b.name
group by a.name; Received on Fri Dec 10 1999 - 10:04:31 CST