Re: Need help with a SQL query

[Quoted] select 'a' as ATTRIBUT , count(*) as no from table1 where a is not null UNION
select 'b' as ATTRIBUT, count(*) as no from table1 where b is not null UNION
select 'c' as ATTRIBUT, count(*) as no from table1 where c is not null

"Anders Windelhed" <anders_at_underlandstudios.com> wrote in message news:txqga.30193$oe.93724_at_amstwist00...
> 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 Thu Mar 27 2003 - 01:51:34 CET