create table cate(?id int primary key,?cateName nvarchar(50),?countScore float,--分數?ctime smalldatetime default(getdate())--添加該類別時間)create table kplan(?id int identity(1,1) primary key,?username nvarchar(30) foreign key references Users(username),?cid int? foreign key references cate(id),--類別id外鍵?context text,--內容?ptime nvarchar(12),--幾月份(上中下旬)計劃時間?publishTime smalldatetime default(getdate()),--填寫時間?sIf nvarchar(10) default('未審核')--已審核、未審核)create table kpractice(?id int identity(1,1) primary key,?username nvarchar(30) foreign key references Users(username),?cid int? foreign key references cate(id),--類別id外鍵?practice?? text,,--得分?ptime nvarchar(12)--幾月份(上中下旬)計劃時間?publishTime smalldatetime default(getdate()),--填寫時間)我寫的語句是：select c.id as id,c.cateName as cateName,k.context as context,c.countScore as countScore,p.practice from ((kplan as k inner join cate as c on k.cid=c.id) inner join kpractice as?p on p.cid=c.id) where k.username='張三' and k.ptime='2011年4月上旬' and k.sIf='已審核'得到的結果：id?????? cateName???????????????????????? context? countScore? score1?原有系統常規維護工作是基礎工作? ?aa????????????? 40??????????? ?40 2?新項目建設計劃完成工作?????????????? aa????????????? 40?????????????? 403?其他工作?????????????????????????????????? ?aa????????????? 10?????????????? ?54?學習???????????????????????????????????????? ?aa?????????????? 10??????????????? 51?原有系統常規維護工作是基礎工作?? aa????????????? 40??????????????102?新項目建設計劃完成工作?????????????? aa????????????? 40?????????????? 113?其他工作??????????????????????????????????? aa?????????????? 10????????????? ?104?學習???????????????????????????????????????? ?aa??????????????? 10????????????? 10怎么去除每行的重復項呢？請教高手？