求教一条合并两个数据表的查询语句,详情如下:

Question

declare @Weekly table(Week_num varchar(6),WStart DateTime,WEnd DateTime)
insert into @Weekly values('200601','2006-01-01','2006-01-05')
insert into @Weekly values('200602','2006-01-06','2006-01-12')declare @DailyAttend table(EM_ID varchar(6),ADate DateTime,ATimes Numeric(9,2))
insert into @DailyAttend values(1,'2006-01-01','9.0')
insert into @DailyAttend values(1,'2006-01-02','8.0')
insert into @DailyAttend values(1,'2006-01-03','9.5')
insert into @DailyAttend values(1,'2006-01-04','8.5')
insert into @DailyAttend values(1,'2006-01-05','9.0')
insert into @DailyAttend values(1,'2006-01-06','9.0')
insert into @DailyAttend values(1,'2006-01-07','9.0')
insert into @DailyAttend values(2,'2006-01-01','9.0')
insert into @DailyAttend values(2,'2006-01-02','9.0')
insert into @DailyAttend values(2,'2006-01-03','9.0')
insert into @DailyAttend values(2,'2006-01-04','9.0')Select w.Week_num,ADate,EM_ID,ATimes
From @Weekly w,@DailyAttend d
Where d.ADate Between w.WStart And w.WEnd
Order By Week_num,ADate

Answer 1

To:lzhs(快乐至上),    同行!有同感哦!
    我专做项目的,还做MRPII,ERP等,交个朋友好吗?我在广州,[email protected]