Combining multiple queries

[xtreemnet]

Hi,

How do I combine multiple queries as below into one row?

Select count(a) as cnta from s;
Select count(b) as cntb from t;

Display them as one row as:
count(a), count(b)

Thanks,

 

[xtreemnet]

I have found the solution. I can use it as below:

Select (Select count(a) as cnta from s) as ca,
(Select count(b) as cntb from t) as cb

The out looks as:

ca cb
23 45