Re: RANDOM in GROUP BY

2003-11-14 Thread Colleen Dick
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

Re: RANDOM in GROUP BY

2003-11-14 Thread Roger Baklund
* 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