This sql query doesn't work any help?

See more:

SQL

Select *
From
(
Select new_do_presentation,COUNT(new_do_presentation) as presentation
from FilteredNew_dineintakeawaycommentcard
where createdon > '7/25/2011'
and createdon <'7/27/2011'
Group by new_do_presentation


UNION

Select new_do_temperature,COUNT(new_do_temperature) as temperature
from FilteredNew_dineintakeawaycommentcard
where createdon > '7/25/2011'
and createdon <'7/27/2011'
Group by new_do_temperature

UNION

Select new_do_taste,COUNT(new_do_taste) as taste
from FilteredNew_dineintakeawaycommentcard
where createdon > '7/25/2011'
and createdon <'7/27/2011'
Group by new_do_taste
)AS tab
Group by new_do_taste, new_do_temperature,new_do_presentation;

The real Problem is that this query make select with repetition(Even I use Group By)(every task Work normaly when i selected in the same table make this problem)


What i need is to select 3 columns from X tables (this columns contain YES Or No values)then i need to see each columns how many times contain yes and no