请问这个实际问题的SQL怎么写

[marongc]

A 介绍 B,C,D ,然后B介绍M,N, C介绍R,P,Q, D没有介绍别人.假如每个人都有2000的营业额,现在我想看每个人的营业额及每个人含下属的营业额之和.这个用SQL要怎么写

CREATE TABLE [dbo].[emp1](
	[code] [nvarchar](50) NOT NULL,
	[name] [nvarchar](50) NULL,
	[jsr] [nvarchar](50) NULL,
 CONSTRAINT [PK_tab1] PRIMARY KEY CLUSTERED 
(
	[code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE TABLE [dbo].[sale1](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[code] [nvarchar](50) NULL,
	[moth] [nvarchar](50) NULL,
	[qnt] [float] NULL,
 CONSTRAINT [PK_sale1] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


INSERT INTO emp1 (code, name,jsr)
SELECT 'A','A','' UNION ALL
SELECT 'B','B','A' UNION ALL
SELECT 'C','C','A' UNION ALL
SELECT 'D','D','A' UNION ALL
SELECT 'M','M','B' UNION ALL
SELECT 'N','N','B' UNION ALL
SELECT 'R','R','C' UNION ALL
SELECT 'P','P','C' UNION ALL
SELECT 'Q','Q','C' 

INSERT INTO sale1 (code, qnt)
SELECT 'A',2000 UNION ALL
SELECT 'B',2000 UNION ALL
SELECT 'C',2000 UNION ALL
SELECT 'D',2000 UNION ALL
SELECT 'M',2000 UNION ALL
SELECT 'N',2000 UNION ALL
SELECT 'R',2000 UNION ALL
SELECT 'P',2000 UNION ALL
SELECT 'Q',2000 

我想要的结果:
工号,个人业绩,下属业绩之和
A,2000,16000
B,2000,4000
C,2000,6000
D,2000,0
M,2000,0
N,2000,0
R,2000,0
P,2000,0
Q,2000,0

[哥眼神纯洁不]

同一个问题问两遍啊...那个回你了

[marongc]

我以为我放错版块了,所以在这边又问一下,先谢谢了

[marongc]

如果用我那边的表怎么写,我消化不了,呵呵 能不能再麻烦一下,帮一下我

[开启时代]

慢慢消化 别着急