要比较的 SQL 查询
我正在使用 Access 数据库,需要在其中提取一些报告。对于其中一个,我需要比较两个数字列表,List1 和 List2(我从单独的查询中获得这两个列表)并仅显示 List1 中但不在 List2 中的那些数字。
有人可以帮忙吗? 谢谢。
I am working on an Access database and in it I need to extract several reports. For one of them I need to compare two lists of numbers, List1 and List2(I get both from separate queries) and display only those numbers that are in List1 but not in List2.
Can anyone help please?
Thank you.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
其他人在 SQL 中提供了一些很好的答案,但您可能希望使用 Access 的一些内置功能。
当我处于查询屏幕时(在 Access XP/2002 中,但对于 Access 2003 应该是相同的),我可以单击“新建”,然后有一个“查找不匹配的查询”选项向导。这将引导您完成一系列对话框,帮助您设置要查找的查询。在执行此向导之前,您需要已经定义“List1”和“List2”(来自您的示例)。
设置完成后,您将能够看到 Access 如何创建查询,这是一种很好的学习方式。
Others have provided some good answers in SQL, but you may wish to use some of the built-in functionality of Access.
When I'm in the query screen (in Access XP/2002, but it should be the same for Access 2003), I can click
New
and then there is an option forFind Unmatched Query Wizard
. This will walk you through a series of dialog boxes that help you set up the query you are looking for. You will need to have "List1" and "List2" (from your example) already defined before going through this wizard.After you have this set up, you'll be able to see how Access created the query, which is a great way to learn.
您可以使用
LEFT OUTER JOIN
来完成此操作You can do this using a
LEFT OUTER JOIN