您可能需要考虑以下几点:

SELECT n1.ID, n1.Field2
FROM New AS n1 
INNER JOIN 
     (SELECT ID, Field2 
      FROM New IN 'c:\docs\ltd.mdb') AS n2 
ON n1.ID = n2.ID
WHERE n1.Field2<>n2.Field2

还有许多其他可能性，包括使用VBA比较整个数据库选择中的每个表.

Access提供了一个查询设计窗口"，在学习如何设置查询时非常有用，但对于更高级的SQL而言却没有那么有用.

以下是一些有趣的文章:

Fundamental Microsoft Jet SQL for Access 2000
Intermediate Microsoft Jet SQL for Access 2000
Advanced Microsoft Jet SQL for Access 2000

Hallo experts,

i want to compare the values of two cells in two tables of two mdb. After googling I find that tablediff could perhaps help me in this issue. Could you give me a simple example with this command in case of my problem?

Many thanks in advance,

John

You might like to consider something on these lines:

SELECT n1.ID, n1.Field2
FROM New AS n1 
INNER JOIN 
     (SELECT ID, Field2 
      FROM New IN 'c:\docs\ltd.mdb') AS n2 
ON n1.ID = n2.ID
WHERE n1.Field2<>n2.Field2

There are numerous other possibilities, including using VBA to compare every table in the entire selection of databases.

Access provides a Query Design Window, which is very helpful when learning how to set up queries, but not so useful for the more advanced SQL.

Here are some interesting articles:

Fundamental Microsoft Jet SQL for Access 2000
Intermediate Microsoft Jet SQL for Access 2000
Advanced Microsoft Jet SQL for Access 2000