with dm.ADOQuery1 do begin close; sql.Clear; sql.Text:='select sum(chanpin_shu*chanpin_price) as cg from chanpin'; //计算总收入 open; form5.Label5.Caption:=string(FieldValues['cg']); 这个程序只是计算总收入,而我现在想要计算采购合同的总收入,而这个采购合同的字段又在另一表edit上,chanpin和edit是通过ht_num字段相关联的!帮帮我,给我提提意见!谢了
----------------------------------------------
我是菜鸟!
加个条件不就可以了吗?select sum(chanpin_shu*chanpin_price) as cg from chanpin,edit where chanpin.ht_num=edit.ht_num '
----------------------------------------------
-