Hi,i need little help with the query i am returning a count on certain column based on different condition like SELECT fld1, fld2, COUNT(fld3) AS test1 FROM table1 WHERE (fld3 = 'value1') GROUP BY fld1, fld2 UNION ALL SELECT fld1, fld2, COUNT(fld3) AS test2 FROM table1 WHERE (fld3 = 'value2') GROUP BY fld1, fld2 i get the result something like this thru the union all fld1, fld2 test1