You are almost right!-- Prepare sample data to mimic your environmentDECLARE @Tb1 TABLE (StationID INT, Day INT, No_In INT)INSERT @Tb1SELECT 1, 2, 90 UNION ALLSELECT 1, 5, 80 UNION ALLSELECT 1, 4, 10DECLARE @Tb2 TABLE (StationID INT, Day INT, No_Out INT)INSERT @Tb2SELECT 1, 2, 70 UNION ALLSELECT 1, 1, 10 UNION ALLSELECT 1, 3, 90 UNION ALLSELECT 1, 5, 60-- Show the expected outputSELECT d.StationID, d.Day, SUM(d.No_In) AS No_In, SUM(d.No_Out) AS No_OutFROM ( SELECT StationID, Day, No_In, 0 AS No_Out FROM @Tb1 UNION ALL SELECT StationID, Day, 0, No_Out FROM @Tb2 ) AS dGROUP BY d.StationID, d.DayORDER BY d.StationID, d.Day
E 12°55'05.25"N 56°04'39.16"