SELECT CountDD,CountTotal,CountDD/CountTotal AS Ratio
FROM [SELECT 1 AS tempfield, COUNT(*) AS CountDD
FROM (SELECT *,1
FROM info1
UNION
SELECT *,2
FROM info2) x
WHERE x.info = '满意']. AS A LEFT JOIN
[SELECT 1 AS tempfield,COUNT(*) AS CountTotal
FROM (SELECT *,1
FROM info1
UNION
SELECT *,2
FROM info2) y]. AS B ON A.tempfield=B.tempfield;
SELECT CountDD/CountTotal AS Ratio
FROM [SELECT 1 AS tempfield, COUNT(*) AS CountDD
FROM (SELECT *
FROM info1
UNION
SELECT *
FROM info2) x
WHERE x.info = '满意']. AS A LEFT JOIN [SELECT 1 AS tempfield,COUNT(*) AS CountTotal
FROM (SELECT *
FROM info1
UNION
SELECT *
FROM info2) y]. AS B ON A.tempfield=B.tempfield;
var a1,a2,b1,b2: integer;
pre: double;
begin
with adoquery1 do
begin
close;
sql.clear;
sql.text := 'select count(*) as a from a表 where 字段1 = 满意';
open;
a1 := fieldbyname('a').integer;
close;
sql.clear;
sql.text := 'select count(*) as a from b表 where 字段1 = 满意';
open;
b1 := fieldbyname('a').integer;
close;
sql.clear;
sql.text := 'select count(*) as a from a表 ';
open;
a2 := fieldbyname('a').integer;
close;
sql.clear;
sql.text := 'select count(*) as a from b表 ';
open;
b2 := fieldbyname('a').integer;