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!!

[Tim Craig]

Cross posting is considered bad form here. Your question is SQL related and you've posted it the SQL forum.

You measure democracy by the freedom it gives its dissidents, not the freedom it gives its assimilated conformists.