SQL.Text:='select a.强度等级 ,sum(b.方量) as 完成总量, a.水泥 as 水泥配比量, a.水泥*sum(b.方量) as 水泥方量, a.水泥单价, a.水泥单价*a.水泥*sum(b.方量) as 水泥合计';
SQL.Add(' a.外加剂 as 外加剂配比量, a.外加剂*sum(b.方量) as 外加剂方量, a.外加剂单价, a.外加剂单价*a.外加剂*sum(b.方量) as 外加剂合计');
SQL.Add(' a.矿粉 as 矿粉配比量, a.矿粉*sum(b.方量) as 矿粉方量, a.矿粉单价, a.矿粉单价*a.矿粉*sum(b.方量) as 矿粉合计');
SQL.Add(' a.粉煤灰 as 粉煤灰配比量, a.粉煤灰*sum(b.方量) as 粉煤灰方量, a.粉煤灰单价, a.粉煤灰单价*a.粉煤灰*sum(b.方量) as 粉煤灰合计');
SQL.Add(' a.碎石 as 碎石配比量, a.碎石*sum(b.方量) as 碎石方量, a.碎石单价, a.碎石单价*a.碎石*sum(b.方量) as 碎石合计');
SQL.Add(' a.砂子 as 砂子配比量, a.砂子*sum(b.方量) as 砂子方量, a.砂子单价, a.砂子单价*a.砂子*sum(b.方量) as 砂子合计');
SQL.Add(' from 配合比 a left outer join 送货单 b on a.强度等级=b.强度等级 group by a.强度等级');
提示“SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。”我实在是检查不出来了,请高手们给查查~~~~~~~
SQL.Add(' a.外加剂 as 外加剂配比量, a.外加剂*sum(b.方量) as 外加剂方量, a.外加剂单价, a.外加剂单价*a.外加剂*sum(b.方量) as 外加剂合计');
SQL.Add(' a.矿粉 as 矿粉配比量, a.矿粉*sum(b.方量) as 矿粉方量, a.矿粉单价, a.矿粉单价*a.矿粉*sum(b.方量) as 矿粉合计');
SQL.Add(' a.粉煤灰 as 粉煤灰配比量, a.粉煤灰*sum(b.方量) as 粉煤灰方量, a.粉煤灰单价, a.粉煤灰单价*a.粉煤灰*sum(b.方量) as 粉煤灰合计');
SQL.Add(' a.碎石 as 碎石配比量, a.碎石*sum(b.方量) as 碎石方量, a.碎石单价, a.碎石单价*a.碎石*sum(b.方量) as 碎石合计');
SQL.Add(' a.砂子 as 砂子配比量, a.砂子*sum(b.方量) as 砂子方量, a.砂子单价, a.砂子单价*a.砂子*sum(b.方量) as 砂子合计');
SQL.Add(' from 配合比 a left outer join 送货单 b on a.强度等级=b.强度等级 group by a.强度等级');
提示“SELECT 子句中包含一个保留字、拼写错误或丢失的参数,或标点符号不正确。”我实在是检查不出来了,请高手们给查查~~~~~~~
a.外加剂 as 外加剂配比量, a.外加剂*sum(b.方量) as 外加剂方量, a.外加剂单价, a.外加剂单价*a.外加剂*sum(b.方量) as 外加剂合计
a.矿粉 as 矿粉配比量, a.矿粉*sum(b.方量) as 矿粉方量, a.矿粉单价, a.矿粉单价*a.矿粉*sum(b.方量) as 矿粉合计
a.粉煤灰 as 粉煤灰配比量, a.粉煤灰*sum(b.方量) as 粉煤灰方量, a.粉煤灰单价, a.粉煤灰单价*a.粉煤灰*sum(b.方量) as 粉煤灰合计
a.碎石 as 碎石配比量, a.碎石*sum(b.方量) as 碎石方量, a.碎石单价, a.碎石单价*a.碎石*sum(b.方量) as 碎石合计
a.砂子 as 砂子配比量, a.砂子*sum(b.方量) as 砂子方量, a.砂子单价, a.砂子单价*a.砂子*sum(b.方量) as 砂子合计
from 配合比 a left outer join 送货单 b on a.强度等级=b.强度等级 group by a.强度等级
select a.强度等级 ,sum(b.方量) as 完成总量, a.水泥 as 水泥配比量, a.水泥*sum(b.方量) as 水泥方量, a.水泥单价, a.水泥单价*a.水泥*sum(b.方量) as 水泥合计,
a.外加剂 as 外加剂配比量, a.外加剂*sum(b.方量) as 外加剂方量, a.外加剂单价, a.外加剂单价*a.外加剂*sum(b.方量) as 外加剂合计,
a.矿粉 as 矿粉配比量, a.矿粉*sum(b.方量) as 矿粉方量, a.矿粉单价, a.矿粉单价*a.矿粉*sum(b.方量) as 矿粉合计,
a.粉煤灰 as 粉煤灰配比量, a.粉煤灰*sum(b.方量) as 粉煤灰方量, a.粉煤灰单价, a.粉煤灰单价*a.粉煤灰*sum(b.方量) as 粉煤灰合计,
a.碎石 as 碎石配比量, a.碎石*sum(b.方量) as 碎石方量, a.碎石单价, a.碎石单价*a.碎石*sum(b.方量) as 碎石合计,
a.砂子 as 砂子配比量, a.砂子*sum(b.方量) as 砂子方量, a.砂子单价, a.砂子单价*a.砂子*sum(b.方量) as 砂子合计,
from 配合比 a left outer join 送货单 b on a.强度等级=b.强度等级 group by a.强度等级