السلام عليكم
PHP كود :
procedure TForm1.Button3Click(Sender: TObject);
var
sSql: string;
begin
sSql := 'SELECT sum (details_sell.qty*classess_table.buy_price) AS cost ' +
'FROM classess_table INNER JOIN details_sell ON ' +
'classess_table.ClassID = details_sell.class_id';
ADODataSet2.Close;
ADODataSet2.Prepared;
ADODataSet2.CommandText := sSQl;
ADODataSet2.Open;
Edit3.Text:= ADODataSet2.Fields[0].AsString;
ADODataSet2.Close;
end;

