加入三张桌子 [英] joining three tables

问题描述

我有三个表，我没有使用关系数据库，我使用简单的数据库，问题是数据重复所以所以我没有使用rdbms和没有关系。

现在当我通过简单地比较simliar列和所有表来加入这三个表，它们组合在一起但是它们的值变得错误，值得到改变它重复。



任何解决方案？



在这个问题部分我不能粘贴任何图像我怎么能这样做，这将有助于任何onw更好地理解问题。

解决方案

我需要找到一个合适的例子，而不是试图从头开始解释。



看看这篇文章

http://stackoverflow.com/questions/19367565/sql-inner-join -wih-multiple-table [ ^ ]

（我知道它说的是sql但它是用于Access）



你可以欺骗访问，认为它只使用该链接显示的技术加入两个表



- 如果这不能解决您的问题，请在访问中转到SQL视图并将您的查询复制到您的帖子中，我会再试一次

i have three tables ,and i am not using relational database,i am using simple database ,problem is data is repeating in all so i didnt use rdbms and no relationship.
now when i am joining this three tables using simple comparing the simliar column an all tables, they get combined but their value becomes wrong ,value gets changed it repeats.

any solutions?

and in this asking section i cant paste any image how can i do so here that will help any onw to better understand the problem.

解决方案

I needed to find a suitable example rather than trying to explain from scratch.

Have a look at this post
http://stackoverflow.com/questions/19367565/sql-inner-join-wih-multiple-table[^]
(I know it says "sql" but it is for Access)

You can "trick" access into thinking that it is only joining two "tables" using the technique shown at that link

[Edit] - if this doesn't solve your problem, goto the SQL View in access and copy your query into your post and I'll try again

这篇关于加入三张桌子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！