NHibernate - HQL 和深度内连接
我想知道哪些星系的行星上有“间谍”类型的卫星和人类。
我在编写不同深度级别的多个内部连接时遇到困难。
这是我的尝试之一：
select gal from Galaxy gal inner join gal.PlanetList planets
inner join planets.SattelitesList satts,
planets inner join planets.SpeciesList spec
where spec.Name = 'Human' AND satts.Type = 'Spy'
我知道这可行，但它只有一个深度分支（就像二叉树的单个分支）：
select gal from Galaxy gal inner join gal.PlanetList planets
inner join planets.SattelitesList satts where satts.Type ='Spy'
谢谢
I want to know the gallaxies which has planets that have sattelites of type 'Spy' and human species.
I'm having difficulty writing multiple inner joins of different depth levels.
Here is one of my tries:
select gal from Galaxy gal inner join gal.PlanetList planets
inner join planets.SattelitesList satts,
planets inner join planets.SpeciesList spec
where spec.Name = 'Human' AND satts.Type = 'Spy'
I know that this works, but it has only one branch of depth (like a single branch of a binary tree):
select gal from Galaxy gal inner join gal.PlanetList planets
inner join planets.SattelitesList satts where satts.Type ='Spy'
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
这样不行吗？
Doesn't work like this?