db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Legolas Woodland <legola...@gmail.com>
Subject How to select a random record.
Date Sun, 25 Dec 2005 20:46:56 GMT
Thank you for reading my post.
I have a Product table and a category table.
some of products exists in more than one category.
I should select a random product from product table (a record)  and it 
should be from some certain categories.
Now the question is :
What is best solution to select a random product which is in one or more 
categories ( categories are  determined by users ).

Thank you

View raw message