设计终极加入Access [英] Design Ultimate Join in Access

问题描述

如何进行最终加入？ [注意：SQL或任何数据库中不存在终极连接一词]



数据库： - https://www.dropbox.com/s/lti39imuia7uksx/1.png [ ^ ]



从上面的链接我希望答案为苛刻 - > Yash-> Yugank-> Pankaj-> Priyanka-> Miller基于IId与Id的连接。如何实现这个目标？

首选数据库使用（访问）。



提前致谢

How to make an ultimate join? [Note : word "ultimate join" does not exists in SQL or any DB]

Database :- https://www.dropbox.com/s/lti39imuia7uksx/1.png[^]

from the link above i want the answer as "Harsh->Yash->Yugank->Pankaj->Priyanka->Miller" on the basis of joining of "IId" with "Id". How to achieve this?
Preferred database use (Access).

Thanks in advance

推荐答案

SQL语法和语义是基于集合意味着它们为您提供2维结果，它不是树或图形为导向。



要获得你想要什么，你需要自己递归查询和积累结果。

The SQL syntax and semantics are "set based" meaning they give you 2 dimensional results, it is not tree or graph orientated.

To get what you want you need to recursively query and accumulate the results yourself.

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