A HUGE THANK YOU
I had almost given up doing this in a query, it works!
I knew there had to be something like this, just couldn't quite
snag it most of my queries are pedestrian to say the least.
It may be inefficient --and I see why it is-- but would it not be less
so for the dbms to do th
* Colleen Dick
> This stumped them in PHPbuilder...
>
> I have a table lets call it moms
> each row in the moms table can have many kids,
> and some "kids" have >1 "mom". I have a kid table
> and I have a mxk map table to relate them.
>
> what I want to do is select all the moms and for each mom I
This stumped them in PHPbuilder...
I have a table lets call it moms
each row in the moms table can have many kids,
and some "kids" have >1 "mom". I have a kid table
and I have a mxk map table to relate them.
what I want to do is select all the moms and for each mom I want a
random one of its kids