Question

执行SQL时提示,SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确.请大伙帮帮忙

语句如下:sql1="SELECT Depart.depart_name as aa, Employee.emp_name as bb, TimeRecords.sign_time as cc"&_
"FROM (Employee INNER JOIN TimeRecords ON Employee.card_id = TimeRecords.card_id) INNER JOIN Depart ON Employee.depart_id = Depart.depart_id"

rs.open sql1,com,1,1
谢谢你,在你回答之前我已解决了,就是cc"&_
"FROM (Employee
的问题,后来我将SQL读出来看,到底哪有问题,结果就解决了,还是谢谢你

Answer 1

你代码中 TimeRecords.sign_time as cc"&_
"FROM (Employee
这部分,当运行时，from关键字 和 前面的cc连在一起了， 有些问题

改成
TimeRecords.sign_time as cc "&_
" FROM (Employee

Answer 2

haha