MNTH YEAR DATE T1 | OMNTH YEAR DATE T2 JAN 2017 22/1/17 CC | .... .... ... .. etc.........
MNTH YEAR DATE T1 T2 T3 T4 T5 JAN 2017 22/1/17 CC .. .. .. ..
var qry = " SELECT month,T1,T2,T3,T4,T5 FROM T1 AS m FULL JOIN T2 AS o ON m.month = o.omonth and m.year=o.year FULL JOIN T3 AS s ON s.smonth = o.omonth and s.year=o.year FULL JOIN T4 AS t ON t.tmonth = m.month and t.year=m.year FULL JOIN T5 AS p ON p.spmonth=o.omonth and p.year=o.year where m.date between '" + dateTimePicker6.Value.ToString("yyyy/MM/dd") + "' and '" + dateTimePicker5.Value.ToString("yyyy/MM/dd") + "'"
LEFT JOIN
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)