On Sunday 15 June 2003 08:44 am, wrote: > Greetings- > > I request your help constructing a query to return a list of active members > based on the following: ....
select distinct members.members_number, members.name, status.status from members,status where status.status='Active' and status.date<='2000-07-01' order by status.date desc should do it. this should return the last status entry prior to the date entered, which I think is what you want. Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
