status of 4.0

I can't seem to find any real currect new about a stable Mysql 4.0 release, anyone know more about this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

help me with complicate sql query

Hello sql guru's, I need help find SQL to solve a problem: I have two tables, the first is persons: person_id int unsigned not null auto_increment firstname varchar(25) lastname varchar(25) The second is person_orgs person_id int unsigned not null org_id int unsigned not null A person may be

Help with sql syntax

I have three tables as follows (simplified): persons (person_id,person) skills( skill_id,skill) person_skills( person_id,skill_id) A person can have one or more entries in the person_skills table, indicating their skills. I need to select persons where there skills match ALL skill_id's in a set