在线等,很急....!!!

[wumylove1234]

SELECT tblDept.*, [tblEmployee].[ID]
FROM tblDept INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]

这样的查询在Access的查询设计器里可以通过,为什么我在ADO里就提示"表达式错误"?????

[Andy__Huang]

注意，你的語句有問題，你的ID好象不對吧？

SELECT tblDept.*, [tblEmployee].[DepID]
FROM tblDept INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]

[titan90]

select tabldept.*,tblemployee.depid
from tabldept inner join tablemployee on tabldept.id=tablemployee.depid

[flyingZFX]

ACCESS

呵呵，，
好像不支持吧，，，

我以前也是这样的，，

ACCESS不支持FROM tblDept INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]这种写法的

[xiaoxiaoP]

SELECT tblDept.*, [tblEmployee].[DepID]
FROM tblDept, tblEmployee INNER JOIN tblEmployee ON [tblDept].[ID]=[tblEmployee].[DepID]

[xiaoxiaoP]

或者是：

SELECT tblDept.*, tblEmployee.DepID
FROM tblDept, tblEmployee where tblDept.ID=tblEmployee.DepID