help with complex query please (corrected)

2004-07-27 Thread Greg Sloman
Using MySQL: 3.23.46 (Correction) The select query below returns a grouped list of all featured artists. Their images are listed in a random order within each artist group. Is it possible to still return *all* featured artists (there are 6) but only a random selection of no greater than 2 ima

help with complex query please

2004-07-27 Thread Greg Sloman
Using MySQL: 4.23.46 The select query below returns a grouped list of all featured artists. Their images are listed in a random order within each artist group. Is it possible to still return *all* featured artists (there are 6) but only a random selection of no greater than 2 images from each