Добрый день, у меня возникла такая вот проблема (ниже представлен запрос) Он почему-то не хочет работать Код (Text): SELECT timetable.id, lesson_time.name AS time, timetable.second_week as week, day.name as day_name, day.id as day_id, group.name as nameg, timetable.group_id as gr, subjects.name AS subject1, sub.name AS subject2, teacher1.name as teacher1, teacher2.name as teacher2, teacher3.name as teacher3, teacher4.name as teacher4, lessons1.name AS type1, lessons2.name AS type2, auditory1.auditory_number AS auditory1, auditory2.auditory_number AS auditory2, corps1.number AS corp1, corps2.number AS corp2 FROM timetable LEFT OUTER JOIN lesson_time ON lesson_time.id=timetable.lesson_num LEFT OUTER JOIN lessons lessons1 ON lessons1.id=timetable.lesson_type1 LEFT OUTER JOIN lessons lessons2 ON lessons2.id=timetable.lesson_type2 LEFT OUTER JOIN users teacher1 ON teacher1.id=timetable.teacher1_1 LEFT OUTER JOIN users teacher2 ON teacher2.id=timetable.teacher1_2 LEFT OUTER JOIN users teacher3 ON teacher3.id=timetable.teacher2_1 LEFT OUTER JOIN users teacher4 ON teacher4.id=timetable.teacher2_2 LEFT OUTER JOIN subjects ON subjects.id=timetable.subject1 LEFT OUTER JOIN subjects sub ON sub.id=timetable.subject2 LEFT OUTER JOIN auditory auditory1 ON auditory1.id=timetable.audit1 LEFT OUTER JOIN auditory auditory2 ON auditory2.id=timetable.audit2 LEFT OUTER JOIN corps corps1 ON auditory1.corps_id=corps1.id LEFT OUTER JOIN corps corps2 ON auditory2.corps_id=corps2.id LEFT OUTER JOIN day ON timetable.day_id=day.id LEFT OUTER JOIN group ON group.id=timetable.group_id WHERE 1 Ошибка заключаеться что когда я добавляю group.name as nameg или другое что-то не с таблицы timetable, то запрос не работает. И при проверке в Денвере выдает такую ошибку : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group ON group.id=timetable.group_id WHERE 1 LIMIT 0, 30' at line 36 Помогите, очень надо чтоб заработал!