- Create a cursor on user table
- fetch a row at a time from user table into a variable like @user
- select count(1) from log where log.user = @user
hallian_at_hotmail.com wrote in message <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 - 23:07:24 CST
