tablediff示例 [英] tablediff example

问题描述

Hallo专家

我想比较两个mdb的两个表中两个单元格的值.谷歌搜索之后，我发现tablediff也许可以帮助我解决这个问题.如果遇到问题，您能用这个命令给我一个简单的例子吗?

在此先感谢

约翰

解决方案

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

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

这篇关于tablediff示例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！