Combine queries 1

[abenstex]

Hi everyone,

instead of executing several queries like

SELECT a FROM table WHERE id=1

and

SELECT b FROM table WHERE id=2

I would like to combine the queries. I tried already using subqueries like

SELECT (SELECT a FROM table WHERE id=1), (SELECT b FROM table WHERE id=2)

but without success. Can anyone give me a hint as to how to combine two or more queries on the same table but with different conditions for each field?

 

[r937]

select case when id=1
            then a 
            else NULL  end  as a
     , case when id=2
            then b 
            else NULL  end  as b
  from daTable
 where id in (1,2)

r937.com | rudy.ca

 

[abenstex]

Thanks! That did it!