Order by is working after the group stage.
You would need an aggregate function which chooses a random row.
Some other SQL implementations would not let you select a column that is not
also grouped (eg title) or in an aggregate function as in your select ...
group by ... example.
m
You would need an aggregate concat() function I think its in 5.0
m
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 7:08 AM
To: MySQL
Subject: Is this possible?
I have 2 tables (looks best in fixed width font):
test_items