我的查询SQL语句如下,想要添加的目的表的字段为:name/WorkerNo/CardNo/AHour,
select name,WorkerNo,CardNo,Sum(AddTime)/60 as AHour from tbDoCard
where DMonth=4
Group By name,WorkerNo,CardNo
select name,WorkerNo,CardNo,Sum(AddTime)/60 as AHour from tbDoCard
where DMonth=4
Group By name,WorkerNo,CardNo
where DMonth=4
Group By name,WorkerNo,CardNo
select name,WorkerNo,CardNo,Sum(AddTime)/60 as AHour into NewTable from tbDoCard
where DMonth=4 Group By name,WorkerNo,CardNo
where DMonth=4
Group By name,WorkerNo,CardNo)
有问题请发信息到我的E-mail:[email protected]
(select name,WorkerNo,CardNo,Sum(AddTime)/60 as AHour from tbDoCard
where DMonth=4
Group By name,WorkerNo,CardNo)
tbDoCard1 目的表