SELECT tblDept.*, [tblEmployee].[ID]
FROM tblDept INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]这样的查询在Access的查询设计器里可以通过,为什么我在ADO里就提示"表达式错误"?????
FROM tblDept INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]这样的查询在Access的查询设计器里可以通过,为什么我在ADO里就提示"表达式错误"?????
FROM tblDept INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]
SELECT tblDept.*, [tblEmployee].[DepID]
FROM tblDept, tblEmployee INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]
FROM tblDept, tblEmployee where tblDept.ID=tblEmployee.DepID
from tabldept inner join tablemployee on tabldept.id=tablemployee.depid
好像不支持吧,,, 我以前也是这样的,,ACCESS不支持FROM tblDept INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]这种写法的