> SET @cmd = N'SELECT DISTINCT Well_1.Date, > Well_1.DailyRuntime, Well_1.DailyStarts, Well_1.DailyFlowrate, > Well_2.DailyRuntime, Well_2.DailyStarts, > Well_5.DailyRuntime, Well_5.DailyStarts, > Well_6.DailyRuntime, Well_6.DailyStarts, > Well_7.DailyRuntime, Well_7.DailyStarts > > FROM (((Well_1 left join Well_2 on Well_1.Date = Well_2.Date) > left join Well_5 on Well_1.Date = Well_5.Date) > left join Well_6 on Well_1.Date = Well_6.Date) > left join Well_7 on Well_1.Date = Well_7.Date > > WHERE Well_1.Date between @StartDate and @EndDate > ORDER BY Well_1.Date' >Does every table have unique dates or the dates can be repeated inside a single table?
;with cte1 as (select Date from Table1 union select Date from tabl2 union...), cte2 as (select C1.Date, T1.Fields from cte1 C1 left join Table1 T1 on C1.Date = T1.Date), cte3 as (select C2.*, T2.Fields from cte2 C2 left join Table2 T2 on C2.Date = T2.Date), etc. till 4 select cte5.*,T5.fields from cte5 LEFT JOIN Table5 T5 on cte5.Date = T5.Date