Hi M, This appears to do exactly what I require. Thank you !
Cheers Neil On Wed, Aug 25, 2010 at 1:43 PM, misiaQ <mis...@poczta.fm> wrote: > select ci.*, ct.* from (select name, countrycode from city) ci, country ct > where ci.countrycode = ct.code > > Regards, > m > > -----Original Message----- > From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] > Sent: Wednesday, August 25, 2010 1:23 PM > To: [MySQL] > Subject: Retrieve three columns in sub query > > Hi > > Is it possible in MySQL 5.1 to retrieve three columns in a select sub-query > like below : > > SELECT student_age, SELECT (student_subjects_id, random_mark, subject FROM > student_subjects ORDER BY RAND(), LIMIT 1) > FROM students > WHERE student_age > 10 > ORDER BY RAND() > LIMIT 1 > > I've looked and tried everything, but nothing seems to work... > > Cheers > Neil > > > ---------------------------------------------------------------------- > Kup wlasne mieszkanie za 72 tys. zl. > Sprawdz najlepsze oferty >>> http://linkint.pl/f27c4 > >
