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" <[email protected]> escreveu na mensagem news:[email protected]... > 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/[email protected]
