I thought as much, if anyone else can shed some light that would be great. If not, I'm going to have to write an additional query.
2010/8/25 João Cândido de Souza Neto <j...@consultorweb.cnt.br> > As far as I know sub-queries intends to be an only one column and row > result. > > -- > João Cândido de Souza Neto > > "Tompkins Neil" <neil.tompk...@googlemail.com> escreveu na mensagem > news:aanlkti=djkujcsg=kf29sjsp0yllhmhb02mqzdvzd...@mail.gmail.com... > > 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 > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com > >