I am curious about doing something simular to this... does anyone have an idea
On Wed, 24 Nov 2004 00:43:32 -0500, list 123. wrote:
> Using mySQL 4.0, I would like to know how I can code a query that will change
> the value of Participants.Active from Y to N is for three or more CONSECUTIVE
>
Using mySQL 4.0, I would like to know how I can code a query that will change
the value of Participants.Active from Y to N is for three or more CONSECUTIVE
sessions they have Attendance.Present = 'No'?
The Attendance Table has Attendance.Session which coresponds to
Sessions.SessionID and Attend
