คำสั่ง Sql ไม่สามารถทำงานได้Select Prg_tname AS Std_Major, COUNT(*) AS Num
From (SELECT Std_id FROM
( SELECT A.Std_id ,A.C_id,A.C_no,A.O_id,A.Year
FROM TrainDB.dbo.Student A
INNER JOIN TrainDB.dbo.Training B ON (A.C_id = B.C_id) AND (A.C_no = B.C_no) and (C_Flag = '1') and (C_Type = '1') and (A.O_id = B.O_id) and (A.Year = B.Year_id)
INNER JOIN TrainDB.dbo.Course C ON (C.Oid = B.O_id) AND (C.Course_id = B.C_id)
Where ((C.TyprCou = '01') OR (C.TyprCou = '02' AND A.Posttest >= 28)) AND A.O_id = '1' AND ((Substring(C_Date_Start,7,4)+543 = '2568' AND Substring(C_Date_Start,4,2) >='06' AND Substring(C_Date_Start,4,2) <='12') OR (Substring(C_Date_Start,7,4)+543 = 2568+1 AND Substring(C_Date_Start,4,2) >='01' AND Substring(C_Date_Start,4,2) <='05'))
GROUP BY A.Std_id ,A.C_id,A.C_no,A.O_id,A.Year) A GROUP BY Std_id ) A
INNER JOIN RIMASter.dbo.TNB_Student Z1 ON(A.Std_id = Z1.id_no)
INNER JOIN RIMASter.dbo.TStu_Group Z2 ON(Z1.id_group = Z2.id_group)
INNER JOIN RIMASter.dbo.TMajor Z3 ON(Z2.id_program = Z3.id_program)
INNER JOIN RIMASter.dbo.TFaculty Z4 ON(Z3.id_faculty = Z4.id_faculty)
Where Fac_tname = 'เธงเธดเธเธขเธฒเธจเธฒเธชเธเธฃเน '
GROUP BY Prg_tnameIncorrect syntax near 'เธงเธดเธ'.