COUNT(*)里不能用别名..那就这样写 SELECT (SELECT COUNT(*) FROM A) AZ , (SELECT COUNT(*) FROM B) BZ , (SELECT COUNT(*) FROM C) CZ , (SELECT COUNT(*) FROM D) DZ FROM DUAL;
后面的 条件 的 datetime 说 这一列不明确 select (select count(*) from a)az, (select count(*) from b)bz, (select count(*) from c)cz, (select count(*) from d)dz from A,B,C,D where datetime between 2009 and 2010 说我的 datetime 这一列 不明确
晕 你的datetime 是谁的条件 就加在谁的里面啊 select (select count(*) from a where datetime between 2009 and 2010)az, (select count(*) from b where datetime between 2009 and 2010)bz, (select count(*) from c where datetime between 2009 and 2010)cz, (select count(*) from d where datetime between 2009 and 2010)dz from dual;