select tb.title,tb.code,tb.option,tb.credit,t.name as teacher,tb.classroom,tb.classTime,tb.link from scu.COURSE as tb join CATEGORY as c on c.id = tb.categoryId left join TEACHER as t on t.id=tb.teacher where 1=1 and c.name = '������������' and tb.schoolYear=107 and tb.semester=1 and parentCategory = 'masterDegree' and tb.enable = 1 order by option
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 'option' at line 1
課程名稱 課程編號 選別 學分 上課時間 上課教室 授課教師