Hello,
I am trying to run this on SQL Server 2000. I have 5 tables set up with these fields, in addition to others:
table ug
--------
ugid
table u
-------
uid
fname
lname
table s
-------
uid
cid
total_score
completed
counter
table uga
---------
ugid
uid
table ugl
---------
ugid
uid...