试试:create temporary table t
select username, goodsCount from t1 where username like 'A%' union all
select username, goodsCount from t2 where username like 'A%';select username, sum(goodsCount) group by username;drop table t;
select username, goodsCount from t1 where username like 'A%' union all
select username, goodsCount from t2 where username like 'A%';select username, sum(goodsCount) group by username;drop table t;
( select c1,tid from t1 where tcount >0) a,
( select c2,tid from t2 where tcount >0) b
where a.tid = b.tid都不支持怎麼用呀萬人傳頌的優秀數據庫就是這個樣子的麼?太讓人失望了!
但卻沒辦法通過 recordset 取得數據...可以取得麼?drop 放到前面和放到後面都試過了