Inner Join Table (Mapping table) this is first time i am try mapping table in mysql  i write this procedure  but not work ? whats wrong ?

        DELIMITER $$

       CREATE DEFINER=`root`@`localhost` PROCEDURE `spr_GetInformation`(
                    IN cos_ID INT
                    )
      BEGIN
      SELECT 
                     students.ID as 'StudentID',
                     course.ID as 'CourseID', 
                     students.name,
                     course.course_name, 
                     course.cost_fee, 
                     students_Course.net_cost
            FROM      
                     students INNER JOIN  students_course on students.ID     = students_course.students_ID
                     inner join course on course_ID = students_course.course_ID
            where 
                     course.ID = cos_ID;

END
SELECT 
                 students.ID as 'StudentID',
                 course.ID as 'CourseID', 
                 students.name,
                 course.course_name, 
                 course.cost_fee, 
                 students_Course.net_cost
        FROM      
                 students_course INNER JOIN  students on students.ID     = students_course.students_ID
                 inner join course on course_ID = students_course.course_ID
        where 
                 course.ID = cos_ID;