Because date is not a key field you will need to use sub-queries
SELECT T1.Date, T1.SumOrds, T1.SumValue, T2.SumOrds, T2.SumValue
FROM
(Select Date, Sum(Ords) as SumOrds, Sum(Value) as SumValue FROM Table1 GROUP BY Date) as T1 INNER JOIN
(Select Date, Sum(Ords) as SumOrds, Sum(Value) as...