MYSQL inner join

[Nuthan]

I have a problem where in i wanna use inner join the table and execute these individual query in a single query.
PLEASE Advice!!!

//latest entry
SELECT MAX( time )
FROM jos_porsche_group_reading_task
WHERE q_s_id = '86'
AND group_content_id = '1'

//latest entry with score<>0
SELECT MAX( time )
FROM jos_porsche_group_reading_task
WHERE q_s_id = '86'
AND group_content_id = '1'
AND score <>0

//latest entry with filename<>''
SELECT MAX( time )
FROM jos_porsche_group_reading_task
WHERE student_id = '86'
AND group_content_id = '1'
AND filename<>''

[patjones]

You're just dealing with one table. One possibility is to write these separate queries as sub-queries and JOIN them.