Re: Reducing and counting duplicate rows

2003-12-02 Thread Skippy
On Tue, 2 Dec 2003 10:47:07 +0100 "Wouter van Vliet" <[EMAIL PROTECTED]> wrote: > If you want to select those who HAVE BEEN at level 2 in the yeaer Y, > you can just do "level_id = 2". But I guess you want to know who > currently IS at level 2 IN the year Y? In that case, when using a Yes, that's

RE: Reducing and counting duplicate rows

2003-12-02 Thread Wouter van Vliet
On dinsdag 2 december 2003 4:07 Skippy told the butterflies: > I must admit I'm pretty stumped here. I'm using MySQL 4.0.12. > > I have several tables with info, and one which servers as a > link between them (has id's that refer the id's in all the others). > > The info tables hold people(table