[fw-db] Fetchrow of tableX with a Fetchall of tableY

Hi guys,

I'm trying to fetch a row from 1 table X and then fetch all the rows
from another table Y
and then i want keep on doing that until i've had all rows in table X
(matching a where) and have all the matching rows in Y.

Then i want to put that all in an array and push it to the view.

any ideas on how i can do that?

What i did now was do a fetchall on table X
then foreach do a fetchall on table Y
but then i send those 2 to the view and there i can't figure out how
to make the exact X match the exact Y from the 2arrays.

so i figured combining it is the easiest.

Thanks!
Patrick