Ok, this makes a lot of sense now. (As usual, what seems like more work initially pays off in the end.)
Here's a specific question.
The parent project is called "TiM". We will, at times, want to pull out information for *everyone*. But more often we will want to pull out information just from sub-projects. One of these is "FPP" and another is "WW".
WW right now has only taken place once and did not have any further sub-divisions.
FPP will span about 5 years, and be divided into 3 groups (and possibly more after the initial pilot project).
The people who are in the first group of FPP participants are referred to as "FPP1", the second are "FPP2" (FPP3 has not started yet).
FPP1 involves 28 people broken down into 4 groups (FPP11, FPP12, FPP13, FPP14).
FPP2 involves 19 people broken down into 3 groups (FPP21, FPP22, FPP23).
I want to be able to match all those who are in the DB (i.e. "any TiM participant"), or just those who are in FPP, or just those who are in FPP1, or just those who are in FPP11 (or FPP23, etc).
I'm having trouble figuring out how to be that specific and that broad at the same time. Just not quite getting my head wrapped around it.
TjL
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
