- 积分
- 25
- UID
- 35623
- 阅读权限
- 10
- 注册时间
- 2017-7-10
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
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执行语句时,出现错误。
请问是哪里出现了问题?
谢谢。
|
|