select problem!

[miss YY]

Now ihave do this

select a from table_a where aa=123

select b from table_a where aa=32

select sum(aa) as c from table_a where aa=44

select sum(bb) as d from table_a where aa=88

i want to select them just use one SQL.not use union,because i want to show them like this : a b c d 1 2 32 32 23 43 54 564 32 43 64 45 show four fields,not one,it's difficulty for me,i have done all day long,everyone who can teach me ?very apprciate!!

[April Fans]

select t1.a, t2.b, sum(t3.aa), sum(t4.bb) from table_a as t1,table_a as t2,table_a as t3,table_a as t4 where t1.aa=123,t2.aa=32,t3.aa=44 ,t4.aa=88

April Comm100 - Leading Live Chat Software Provider