Retrieve three columns in sub query

[Tompkins Neil]

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