知道一个id号,怎么获得它的上一级主管的id号?用一句sql语句CREATE TABLE [dbo].[members] (
[Unique_ID] [int] NOT NULL ,
[Account_ID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,--id
[Account_Password] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,--密码
[Dept] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--部门名称
[Dept_ID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--部门id
) ON [PRIMARY]
GOCREATE TABLE [dbo].[Dept] (
[Unique_ID] [int] NULL ,
[Dept_ID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--部门id
[Dept] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--部门名称
[Parent] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--上一级部门id
[Dept_Boss] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL--部门主管id
) ON [PRIMARY]
GO
[Unique_ID] [int] NOT NULL ,
[Account_ID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,--id
[Account_Password] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,--密码
[Dept] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--部门名称
[Dept_ID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--部门id
) ON [PRIMARY]
GOCREATE TABLE [dbo].[Dept] (
[Unique_ID] [int] NULL ,
[Dept_ID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--部门id
[Dept] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--部门名称
[Parent] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,--上一级部门id
[Dept_Boss] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL--部门主管id
) ON [PRIMARY]
GO
from (
select d.Parent
from members m ,Dept d
where m.Unique_ID = d.Unique_ID
and m.Account_ID='id'
) k, Dept s
where k.Parent = s.Dept_ID
Select b.Parent
from members as a
inner join Dept as b on a.Unique_ID=b.Unique_ID
where a.Account_ID='ID') as y on x.Dept_ID=y.Parent
select dept_boss from dept where dept_ID in(select b.parent from members a join dept b on a.dept_ID=b.dept_ID where a.Account_ID='id')
inner join Dept b on a.Dept_ID = b.Dept_ID
inner join Dept c on b.Parent = c.Dept_ID
where a.Unique_ID = @id