SQL Dilemma!! Anyone.........

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 - 20:53:56 CST