CREATE TABLE [dbo].[TM](
[MID] [INT] NOT NULL,
[MNAME] [NVARCHAR](50) NULL,
[MSUM] [MONEY] NULL,
CONSTRAINT [PK_TM] PRIMARY KEY CLUSTERED
(
[MID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TD](
[ID] [INT] NOT NULL,
[MID] [INT] NULL,
[SN] [MONEY] NULL,
CONSTRAINT [PK_TD] 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]
GO
INSERT INTO TM (MID,MNAME,MSUM) values(1,'aa',0)
INSERT INTO TM (MID,MNAME,MSUM) values(2,'bb',0)
INSERT INTO TM (MID,MNAME,MSUM) values(3,'cc',0)
INSERT INTO TM (MID,MNAME,MSUM) values(4,'dd',0)
INSERT INTO TM (MID,MNAME,MSUM) values(5,'ee',0)
INSERT INTO TD(ID,MID,SN) VALUES(101,1,22)
INSERT INTO TD(ID,MID,SN) VALUES(102,1,23)
INSERT INTO TD(ID,MID,SN) VALUES(103,2,1)
INSERT INTO TD(ID,MID,SN) VALUES(104,3,2)
INSERT INTO TD(ID,MID,SN) VALUES(105,3,4)
INSERT INTO TD(ID,MID,SN) VALUES(106,4,6)
INSERT INTO TD(ID,MID,SN) VALUES(107,5,1)