I need to make a query in sql server.. I have two tables
Table#1
Id -- OneDate -- HoursWork
1 -- 25/04/2014 -- 5
2 -- 26/04/2014 -- 7
Table#2
Id -- ADate -- HoursRest
1 -- 25/04/2014 -- 5
Id -- Date -- HoursWork -- HoursRest
1 -- 25/04/2014 -- 5 -- 5
2 -- 26/04/2014 -- 7 -- 0
SELECT table1.id
, table1.onedate
, table1.hourswork
, ISNULL(table2.hoursrest, 0)
FROM table1 LEFT JOIN table2 ON table1.id = table2.id