下面指令用於access可用 select e.* from aready a,cantest c,employee e where a.work_no=c.work_no and e.empno=a.empno and e.empno=c.empno and a.work_no=1 and a.times=0 and e.mark="上班" and c.can_yn=yes 使用於 delphi中則general sql error

改這樣試看看 Query1.SQL.ADD('select e.* from aready a,cantest c,employee e where a.work_no=c.work_no and e.empno=a.empno and e.empno=c.empno and a.work_no=1 and a.times=0 and e.mark=' #39 '上班' #39 ' and c.can_yn=yes '); TRY TRY SEE

OK !! Thanks chih!!