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=arch...@jab.org