问一条SQL
如何将下面2条SQL合并成1条(“ZT_DATA”和“ZT_DATA_History”格式相同)
comm1.CommandText = "SELECT Sum([aa]), Sum([bb]), Sum([cc]), Sum([dd]), Sum([ee]), Sum([ff]) FROM ZT_DATA where 型号= 'qr55 ' "
comm1.CommandText = "SELECT Sum([aa]), Sum([bb]), Sum([cc]), Sum([dd]), Sum([ee]), Sum([ff]) FROM ZT_DATA_History where 型号= 'qr55 ' "
[解决办法]
comm1.CommandText = "SELECT Sum(ZT_DATA.[aa])+Sum(ZT_DATA_History.[aa]), Sum(ZT_DATA.[bb])+Sum(ZT_DATA_History.[bb]), Sum(ZT_DATA.[cc])+Sum(ZT_DATA_History.[cc]), Sum(ZT_DATA.[dd])+Sum(ZT_DATA_History.[dd]), Sum(ZT_DATA.[ee])+Sum(ZT_DATA_History.[ee]), Sum(ZT_DATA.[ff])+Sum(ZT_DATA_History.[ff]) FROM ZT_DATA,ZT_DATA_History where ZT_DATA.型号= 'qr55 ' and ZT_DATA_History.型号= 'qr55 ' "
[解决办法]
"SELECT Sum([aa]), Sum([bb]), Sum([cc]), Sum([dd]), Sum([ee]), Sum([ff]) FROM ZT_DATA where 型号= 'qr55 ' union all SELECT Sum([aa]), Sum([bb]), Sum([cc]), Sum([dd]), Sum([ee]), Sum([ff]) FROM ZT_DATA_History where 型号= 'qr55 ' "
