为什么我的SQL语句在查询设计器里正常工作,在delphi里提示语法错误??
pinyu 2004-11-12 03:11:52 sql语句如下
,把他写到query里说语法错误:
SQL语句如下:
SELECT a.ExamID, a.Name, a.Sex, a.GradeName + a.ClassDictName AS Class, b.语文,
c.数学
FROM ScoreView a INNER JOIN
(SELECT ExamID, score AS 语文
FROM ScoreView
WHERE ExamrecordID = 17) b ON a.ExamID = b.ExamID INNER JOIN
(SELECT ExamID, Score AS 数学
FROM ScoreView
WHERE ExamRecordID = 19) c ON a.ExamID = c.ExamID
错误提示说:
语法错误(操作符丢失)在查询表达式'a.ExamID=b.ExamID INNER JOIN
(Select ExamID,Score AS 数学
FROM ScoreView
WHERE ExamRecordID=19)c ON a.ExamID=c.ExamID'中