Need help with a SQL query

I need help with a SQL query...

I have three queries:

(select 'a' as ATTRIBUT , count(*) as no from table1 where a is not null)

(select 'b' as ATTRIBUT, count(*) as no from table1 where b is not null)

(select 'c' as ATTRIBUT, count(*) as no from table1 where c is not null)

the results from these queries looks like this

attribut no
a 34

and so on...

I would like to combine into one result table like this

attribut no

a           34
b          334
c           23

I know that it would be much easier to create a query that gives the result like this

a b c
34 334 23

but that won't solve my problem =(

Any suggestions?

Best regards

Anders Received on Wed Mar 26 2003 - 16:41:50 CST