-
1 votesanswersviews
SQL Server连接两个表,并保留自己的值和日期
我有两个查询,它给我两组结果: 时间查询: SELECT a.AID AID, CONCAT(CONVERT(date, c.CDate),DATEPART(HOUR, c.CDate)) CDateHour, SUM(c.time/60/1000) duration FROM TableA a INNER JOIN TableB b ON b.bkey = a.akey LEFT JOIN Ta...