比较Access中的两个表 [英] comparing two tables in Access

问题描述

亲爱的所有人，

我是Access的新手，我正在SAP中进行产品层次结构。我必须检查SAP系统和其他文件的数据冗余。然后在SAP系统中更改代码或描述中的差异。


我有两个表。表A有两列，即codeA和descriptionB，表B有两列，也是codeB和descriptionB。我的问题是：


1.如果codeA = codeB，结果为true / false，如果匹配则为1/0。


2。如果codeA = codeB = descriptionB或codeA = codeB = descriptionA，我该如何进行比较。基本上我想检查两个表中的代码是否相同的描述不同。


3.如果可能在不同的表/列中显示错误。


希望有人可以帮助我。谢谢你！我真的很感激。


问候

解决方案

您已在文章部分发布了此问题。我正把它移到Access论坛。


ADMIN

亲爱的所有人，

我是Access的新手，我正在SAP中进行产品层次结构。我必须检查SAP系统和其他文件的数据冗余。然后在SAP系统中更改代码或描述中的差异。


我有两个表。表A有两列，即codeA和descriptionB，表B有两列，也是codeB和descriptionB。我的问题是：


1.如果codeA = codeB，结果为true / false，如果匹配则为1/0。


2。如果codeA = codeB = descriptionB或codeA = codeB = descriptionA，我该如何进行比较。基本上我想检查两个表中的代码是否相同的描述不同。


3.如果可能在不同的表/列中显示错误。


希望有人可以帮助我。谢谢你！我真的很感激。


问候

尝试以下SQL：

展开 | 选择 | Wrap | 行号

尝试以下SQL：

展开 | 选择 | Wrap | 行号

Dear All,
I am new to Ms Access and I am doing Product Hierarchy in SAP. I have to check for redundancy of datas from the SAP system and from another file. Difference found in code or description is then changed in the SAP system.

I have two tables. Table A has two columns which is codeA and descriptionB and Table B with two columns too codeB and descriptionB. My question is:

1. If codeA=codeB and outcome of true/false or 1/0 if it matches.

2. How do I do comparisons if codeA=codeB=descriptionB or codeA=codeB=descriptionA. Basically I would like to check difference in description if the codes in the two tables are the same.

3. If possible to show the errors in a different table/column.

Hope someone can help me out. Thanks a bunch! I truely appreciate it.

Regards

解决方案

You have posted this question in the Articles section. I am moving it to the Access forum.

ADMIN

Dear All,
I am new to Ms Access and I am doing Product Hierarchy in SAP. I have to check for redundancy of datas from the SAP system and from another file. Difference found in code or description is then changed in the SAP system.

I have two tables. Table A has two columns which is codeA and descriptionB and Table B with two columns too codeB and descriptionB. My question is:

1. If codeA=codeB and outcome of true/false or 1/0 if it matches.

2. How do I do comparisons if codeA=codeB=descriptionB or codeA=codeB=descriptionA. Basically I would like to check difference in description if the codes in the two tables are the same.

3. If possible to show the errors in a different table/column.

Hope someone can help me out. Thanks a bunch! I truely appreciate it.

Regards

Try SQL of :

Expand|Select|Wrap|Line Numbers

Try SQL of :

Expand|Select|Wrap|Line Numbers

这篇关于比较Access中的两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！