create table cate(?id int primary key,?cateName nvarchar(50),?countScore float,--分?jǐn)?shù)?ctime smalldatetime default(getdate())--添加該類別時(shí)間)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,--內(nèi)容?ptime nvarchar(12),--幾月份(上中下旬)計(jì)劃時(shí)間?publishTime smalldatetime default(getdate()),--填寫時(shí)間?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)--幾月份(上中下旬)計(jì)劃時(shí)間?publishTime smalldatetime default(getdate()),--填寫時(shí)間)我寫的語(yǔ)句是：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='已審核'得到的結(jié)果：id?????? cateName???????????????????????? context? countScore? score1?原有系統(tǒng)常規(guī)維護(hù)工作是基礎(chǔ)工作? ?aa????????????? 40??????????? ?40 2?新項(xiàng)目建設(shè)計(jì)劃完成工作?????????????? aa????????????? 40?????????????? 403?其他工作?????????????????????????????????? ?aa????????????? 10?????????????? ?54?學(xué)習(xí)???????????????????????????????????????? ?aa?????????????? 10??????????????? 51?原有系統(tǒng)常規(guī)維護(hù)工作是基礎(chǔ)工作?? aa????????????? 40??????????????102?新項(xiàng)目建設(shè)計(jì)劃完成工作?????????????? aa????????????? 40?????????????? 113?其他工作??????????????????????????????????? aa?????????????? 10????????????? ?104?學(xué)習(xí)???????????????????????????????????????? ?aa??????????????? 10????????????? 10怎么去除每行的重復(fù)項(xiàng)呢？請(qǐng)教高手？