从sql server查询Cascade记录 [英] Query Cascade records from sql server

问题描述

嗨朋友，



使用MSSQL Server，

在TableA中，有三个字段（Userid，Username，ManagerId）。

Hi Friends,

Am using MSSQL Server,
In TableA, there are three fields(Userid,Username,ManagerId).

Userid  - Username - ManagerId
32    -    A    -     13
33    -    B     -    32
132    -   C     -    45
211    -   D     -    32
23     -   E     -    76
260     -  F     -    33
206    -   G     -    33
208   -    H     -    211

现在我想要从TableA查询，如

如果UserId 32登录，我想将userid（33,211）的漫画ID设为32，然后将带有managerid的用户ID（260,206,208）设为33和211，依此类推。 ...



问候，

RK

Now I want to query from TableA like
If UserId 32 logsin, I want to take userid(33,211) having mangaer id as 32, then to take userid(260,206,208)having managerid as 33 and 211 and so on....

Regards,
RK

推荐答案

这是自我加入的直接例子



http://www.aspdotnet-suresh.com/2012/07/self-join-query-in-sql-server-self-join.html [< a href =http://www.aspdotnet-suresh.com/2012/07/self-join-query-in-sql-server-self-join.htmltarget =_ blanktitle =New Window> ^ ]



谢谢

--RA

Here is the direct example for self join

http://www.aspdotnet-suresh.com/2012/07/self-join-query-in-sql-server-self-join.html[^]

Thanks
--RA

这篇关于从sql server查询Cascade记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！