kent_73 发表于 2017-7-10 13:38:55

MySQL执行查询语句时出现错误

mysql在执行sql语句时，出现了错误：SQL执行错误#1064，从数据库的响应.

sql语句：
SELECT Max(ttt.RegDate) AS RegDatemax, ttt.UserCode
FROM (SELECT tt1.WrkOrder, tt1.OrderNo, tt1.Style, tt2.UserCode, tt2.RegDate, tt3.Fpaixu
FROM ((SELECT t1.WrkOrder,t1.OrderNo, t1.Style, t2.Fcsgp, t2.FzhugxId
FROM (pywrkord AS t1 INNER JOIN pywrkstp AS t3 ON t1.WrkOrder = t3.WrkOrder) INNER JOIN pypttgx AS t2 ON t3.StepNo = t2.FgongxuId
WHERE t1.OrderNo='PTT-05' AND t1.Style='PTT-17A2605' AND t2.Fcsgp=1) AS tt1 INNER JOIN pytckreg2 AS tt2 ON tt1.WrkOrder = tt2.WrkOrder) INNER JOIN pypttgx AS tt3 ON (tt1.FzhugxId = tt3.FzhugxId) AND (tt2.UserCode = tt3.Fgongxu)) AS ttt
GROUP BY ttt.UserCode


上述sql语句通过其他方法验证（access链接表后，建立查询），是可执行的，但是在使用MYSQL-Front执行语句时，出现错误。

请问是哪里出现了问题？
谢谢。

kent_73 发表于 2017-7-11 13:20:42

是不是因为嵌套查询的问题，盼解！
页: [1]
查看完整版本: MySQL执行查询语句时出现错误