[maher]

Hi

I have this query
and i want to optimize this query (here I use a SELECT and SUB SELECT) and use only one SELECT if possible

Does anyone have any Idea about it.

Thank you in advance

SELECT c.*
FROM course AS c
JOIN student_course AS sc
ON c.id = uc.course_id
WHERE sc.student_id = '5' AND c.level = (SELECT MAX(level) 
                                         FROM course  
                                         JOIN student_course 
                                         ON c.id = sc.course_id)
GROUP BY c.category_id 

[Allan Freitas]

Maher,

It's possible. What Database are you using?

Can You provide sql create tables and inserts(exemples) for the case?

maher, on 30 November 2012 - 05:59 AM, said:

Hi

I have this query
and i want to optimize this query (here I use a SELECT and SUB SELECT) and use only one SELECT if possible

Does anyone have any Idea about it.

Thank you in advance

SELECT c.*
FROM course AS c
JOIN student_course AS sc
ON c.id = uc.course_id
WHERE sc.student_id = '5' AND c.level = (SELECT MAX(level) 
                                         FROM course  
                                         JOIN student_course 
                                         ON c.id = sc.course_id)
GROUP BY c.category_id