SELECT (SELECT COUNT (S1) FROM A WHERE s2 > 3) s1, (SELECT COUNT (B1) FROM B WHERE b2 > 5) b1 FROM DUAL;
select replace(wm_concat(cc),',',' ') "COUNT(S1) COUNT (B1)" from ( select count(S1) cc from A where S2>3 union all select count(B1) cc from B where B2>5 ) temp;
FROM A
WHERE s2 > 3)
s1, (SELECT COUNT (B1)
FROM B
WHERE b2 > 5)
b1
FROM DUAL;
from
(
select count(S1) cc from A where S2>3
union all
select count(B1) cc from B where B2>5
) temp;