I've posted to other groups, but I don't get any replies for this problem! I
wonder if anyone could help here. If people think it's not possible, then
please say! at least I will know.
Okay, I have two tables (for example), with a one to many relationship.
ID (primary key)
areaID (Primay Key)
ID (Foreign Key)
My select query would go something like:
SELECT firstname, lastname, description
FROM helpers, helpareas
WHERE helpers.ID = helpareas.ID
Now, because I could have different numbers of rows in helpareas, I can't
simply put a LIMIT on the rows. So if I want to select only the first 10
helpers, I can't put LIMIT at the end because it would only retrieve the
first 10 joined rows. So, is there any way of overcoming this? What about
telling my anywhere else to look? ANYTHING would be appreciated!
P.S. I'm restricted to using mySQL (for now), so subqueries are out of the
Thanks in advance,