What RDBMS? That would help mucho...
On 10/8/07, Dennis Powers <[EMAIL PROTECTED]> wrote: > I am having a total mental block with this select query and I am hoping > someone might be able to "unstick" my thought process; > > I have a table Looking something like this (abbreviated for the list) > > ImageID GameID > > ImageID is a unique ID number and there can be multiple images for each > GameID. What I am trying to do is create a query where I can select 6 > random imageID's each for a different GameID. Or another way, get one image > from the many for six different gameID's > > Any help would be greatly appreciated. > > > > Best Regards, > > Dennis Powers > UXB Internet - A website design and Hosting Company > 690 Wolcott Road > P.O. Box 6029 > Wolcott, CT 06716 > Tel: (203)879-2844 > http://www.uxbinternet.com/ > http://www.uxb.net/ > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
